Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

Filter by
Sorted by
Tagged with
0
votes
1answer
20 views

Excel - Using Two Data Tables to Build Output Table

I am trying to compare the locations of numbers in two different data tables and create an output summing the total revenue booked per day of the week based off the location of the day of the week in ...
0
votes
1answer
40 views

Excel: filtering text to show rows with certain words AND without certain words

Say I have a table with 3 columns: I want to filter to only show rows that contain an animal from the animal field, but not a place name in the city field. In this example, I want to only return row ...
0
votes
1answer
45 views

Use defined column names in conditional formatting formulars

I have a table with 28 columns. 8 columns are calculated values. The other 20 columns are user-input. Now I want to setup conditional formatting to highlight rows which do not have values in all of ...
0
votes
1answer
39 views

How to add up multiple values for multiple rows in excel and end up with 1 row per unique ID with sums in columns

Basically I have a huge list of data with multiple rows of unique IDs (each ID can appear on multiple rows). I then have multiple variables in no particular order associated with a value. I would like ...
1
vote
2answers
78 views

Create an exploding stacked column chart

I want to create an exploding stacked column chart similar to this: For example, I want to create the graph from the following data: +--------------------------------+--------+--------+ | Process ...
-2
votes
1answer
35 views

How can I change the value of a cell depending on the value of another

I have a cell on my worksheet that holds the amount payable to debtors. I have another cell of amount paid. I need to know how I can be able to make the value of amount payable to decrease with the ...
0
votes
1answer
24 views

Excel says SUMIF formula I try to use to have too few arguments

I am trying to use the SUMIF-formula, but can't seem to work out how it works, and how it want me to input the formula. The formula template is stated as: =SUMIF(range criteria [sum_range]) I have ...
2
votes
1answer
28 views

Shortening long sentence based on lookup-value

Need help: As stated in image below that I need the result in E3 to be "Washington" because based on lookup value in B6:B9 there is a matched-word partially (which is 'Washington') from D3's long ...
0
votes
0answers
12 views

How to preserve pivot chart formatting? [duplicate]

Every time I make changes to my pivot table, the chart formatting reverts back to its original appearance. How do I preserve my chart formatting?
0
votes
0answers
19 views

Create a report in Excel from a Master data using a pre-defined Template

I have bunch of data in a table called master list. I need to copy each and every row of data into a predefined template into separate excel files. My master table is as below named as Master.xls. ...
1
vote
2answers
48 views

Bypassing one of the SUMIFS criteria+criterion if the particular cell is blank

Need help: From the table image below, the result I want in cell M5 using SUMIFS formula is that if cell K5 (validation filter) is blank or "" then the formula of D5:D6,K5 should just bypass. So the ...
0
votes
1answer
18 views

IFS formula to check two different cells

I am trying to create an invoice tracker that has one cell with the options for "Paid", "Past Due" or "Pending". My formula for the cell is =IFS(C3>=0,"Pending", C3<0,"Past Due") C3 is the ...
0
votes
0answers
28 views

How can I format the Excel file that is created by my ssis script package?

I currently have a script task in ssis that takes data from a sql server table and creates an excel file with different sheets for each city in the location column of the sql table. I want to be able ...
1
vote
0answers
15 views

Excel Creates an External Link to Add-In when Transporting Worksheet Between Users

Simply stated, I have a formula in a worksheet that I made on one computer: =setChartAxis("Template","Chart 2","Min","Y","Primary",(Template!C4 - 0.5)) The setChartAxis function itself is from an ...
-1
votes
0answers
31 views

Excel - Sort row data in multiple tables based on sort in master table

I'm sorry if this question has been answered, but I haven't been able to find this anywhere, or what the proper terminology is to look for it. I am creating an attendance tracker in which sheet 1 ...
0
votes
0answers
24 views

How to copy MS Word Table with Images to MS Excel?

I have a Word document that has tables, contain images. When I copy the table and paste in Excel, it losses the applied formats,once Row from Word table is copying in multiple Rows in Excel. Is ...
0
votes
0answers
20 views

Excel(2013) multivariate interpolation options? (4 or 5 dimensions)

I have an Excel(2013) worksheet that consists of approximately 200 rows. Each of the rows needs to interpolate 5 parameters from a data set. The original data set was in two dimensions so it was easy ...
0
votes
0answers
7 views

Slicer updating just one of the Pivot tables within same tab

I Have two pivot tables and a pivot chart in one tab. I've also created a series of slicers, all of which are updating the pivot chart and one of the pivot tables. However, one of the pivot tables isn'...
1
vote
1answer
25 views

Split Range by other Range between it? VBA

Let's say i got the Range B1:BF1 And another, Variable Range (i.E E1:W1) I want to split the Upper with the lower one, so the Result would look like that B1:D1, X1:BF1 Is it possible to save a ...
0
votes
2answers
26 views

How can I apply conditional formatting to rows that get added to a pivot table when it is refreshed?

I have pivot table in an Excel workbook that summarises information from a table in the same workbook. I have applied Conditional Formatting (data bars) to the pivot table. I have added Year & ...
0
votes
1answer
17 views

Excel tables conditionally add to another table

I would like to make a graph that graphs the total number of incidents each child gets into each day, but also make it so as this table is updated with more inputs, the graph will automatically update ...
0
votes
1answer
50 views

Inserting rows without moving the conditional formatting

I'm working on a spreadsheet with a lot of conditional formatting. But I've got one thing that I'd like to change but isn't working as wanted. I'd like to highlight an individual row ( lets say Row ...
0
votes
0answers
7 views

No underlying data for Excel Pivot Table value

On every other row value in a pivot table I'm able to double click the value to see the underlying data that is summed to produce the value, except for 1 row where double clicking the values shows a ...
0
votes
2answers
17 views

Excel Power Query Load Times - Why do dependent queries reload CSV file data?

I have a series of queries in Excel which all depend on an initial query which loads data from CSV files, processes them and loads them into a table in the worksheet. The remaining queries all use ...
0
votes
1answer
12 views

ActiveX Comboboxes in Excel 365 don't work

I have a sheet with some activeX comboboxes. They work properly in Excel 2013. Now I have an Excel - office 365 - version 1808 - build 10730.20264. When I open this very sheet, comboboxes do not ...
0
votes
0answers
23 views

Excel - define a variable to point to a named range

This is a bit complex to explain. I have a spreadsheet which uses named ranges and Lookup to find the correct multiplier for a set of circumstances. Let's say there are two named ranges. One gives ...
0
votes
0answers
19 views

Excel: Need data in one table column to move along with a different related table

I'm creating a risk assessment document. On the first worksheet, I list Threats in no particular order, just a list of items. Based on two other columns (likelihood and impact) we determine overall ...
0
votes
0answers
27 views

Apache POI 4.1 - new XSSFWorkbook causes POIXMLException: Strict OOXML isn't currently supported

I am aware that about 3-4 years ago, there was an issue(bug #57699) with reading .xlsx file (https://stackoverflow.com/questions/37749841/org-apache-poi-poixmlexception-strict-ooxml-isnt-currently-...
0
votes
0answers
28 views

MS Excel - how to prevent vlookups from breaking?

I've created a template that consists of tabs that I vlookup data from. I need to be able to rename the new version of the file without the vlookups breaking. How do I do this? Also, any tips when ...
0
votes
0answers
24 views

Translating time between timezones in Excel using lookup reference data rather than human input timezone offsets

I have an Excel workbook that tracks work time for staff members. Staff are located in multiple countries. In the Excel workbook, there is a column for the worker’s city, the local time, and the time ...
0
votes
2answers
24 views

How do I lock the Plot Area's size so it doesn't resize when I resize the Chart Area? (Excel/Office 365)

I have two pie charts side by side and I want them to be the same size. However, in pie chart #2, I need to move the Data Labels away from the pie chart which means resizing the Chart Area. The ...
-2
votes
0answers
49 views

Formula to sum the number of days employee has worked in the month

I've an excel spreadsheet that tracks movements of operators on various length jobs. All the usual stuff of job number, location, operator name, duration, start date and end date is sum of duration + ...
-1
votes
0answers
11 views

Pivot Table - data summed in two columns with different criteria

I have a pivot table that summarizes Sales per Customer. The data set has month indicator for each transaction. I would like to get the pivot table to have two columns - one for 12 months of 2018; ...
0
votes
1answer
38 views

How to highlight every Monday and add exceptions? CF / VBA

So I'm currently building a calendar, which shows every Workday in a Year(top rows) and a list of people (column). I want to be able to type somewhere (other sheet) the information like the person, ...
1
vote
1answer
36 views

Excel Chart Color - Create charts with conditional formatting on “text value”

I have a data set of Companies/Products with their performances for every quarter. I am creating a lot of graph to display the various performance. Problem: In order to be coherent, I'd like to ...
0
votes
0answers
28 views

Can I create a “button” in excel that would bring up the filter menu for a column that the “button” isn't in?

I'm making a reference guide in excel that has a broad audience and needs to look generally polished and non-technical. Because of this, my idea for implementing sorting and filtering was to hide the ...
-1
votes
1answer
24 views

“Too Many Arguments” with IF Function in Excel

I keep getting an error that there's too many functions. What I'm trying to accomplish is IF there are hours listed in a specific column (Monday to Sunday), then take the date (in cell Y1) minus the ...
0
votes
2answers
48 views

Calculate Distinct Values Based On 4 Conditions (Excel Formula)

I have a table structure as per below: [A] [B] [C] [D] [E] [1] Dog Big 2018 02 123 [2] Dog Big 2018 02 123 [3] Cat Small 2019 05 123 [4] Dog Big ...
0
votes
0answers
18 views

Copy conditionally formatted cells that contain a certain color to another worksheet

I have a file with five worksheets. The main worksheet (STAFFING) has conditionally formatted cells which are different colors. I would like to have the conditionally formatted cells copied to ...
0
votes
2answers
23 views

How to find duplicate values based on column in two spreadsheets and check if the row is an exact match

I have two excel spreadsheets: Header2018 and Header2019 they both contain the same column headers, but with different record entries. Some of these entries are the same, and I want to find which ...
0
votes
1answer
25 views

Detection of duplicates in Microsoft Excel

I have dealt with serial numbers that are stored as text in the cells because sometimes the serial numbers have letters. I encountered something that I don't quite understand about duplicate detection....
-2
votes
2answers
52 views

VBA script to fill cells that contain any text string

I am trying to create a VBA script that will conditionally format a range of cells that contain any text string with a fill color of my choosing. So far, I use an Excel conditional formatting rule to ...
0
votes
2answers
70 views

Merge rows with same color but different value

Let's say I have 4 rows in 2 columns as below | Col 1 | Col 2 | Row 1 | Blue | 54 | Row 2 | Blue | 25 | Row 3 | Red | 21 | Row 4 | Blue | 65 | What I want is for Excel to ...
-2
votes
2answers
106 views

Remove all characters after any number in excel

I have text like: #1 Supermarket 3454 Ubermarket 23478 Single_Token Two Tokens As many tokens as you like And I'd like to remove the last number (when it appears) so I'm left with: #1 Supermarket ...
1
vote
0answers
21 views

Excel display more sheets in the sheet overview [duplicate]

We are using an Excel file that contains numerous worksheets. Navigating these sheets has become a tedious task, we are currently sitting at 43 sheets that need to be navigated to relatively ...
0
votes
0answers
18 views

Modifying Excel Templates from GUI

The Idea In an attempt to speed up a tedious process, I would like to write an application to help out with creating and saving repetitive spreadsheets. The template is always the same, but 3 cells ...
0
votes
1answer
22 views

Need to Stop Excel From Reformatting Numbers

I can't get Excel to leave my numbers alone. I've set my column to "Text" in the format settings, but nothing I do in the number or other formatting is having any effect. It's been going on for a ...
0
votes
0answers
8 views

Unable to click a Submit button on a IE Child pop up window, using Macros

I have been trying to click on a submit button present inside a IE child pop up window, but unable to programmatically do so. The pop up window locks-up the IE and so I am also unable to do an inspect ...
0
votes
0answers
23 views

CSV exported as comma separated and decimal separator is CSV

I have a problem, where i exported some large csv files, and after some time the separator jumped back to default comma, but the problem is that the decimal separator of the software (SQL Developer) ...
1
vote
2answers
37 views

What's the VB code for auto-sorting a range of data based on a text value in Excel?

I have a few columns, important among them being: Tasks, Priority, Status. I want all rows of records where the priority says "High" to automatically update themselves and appear on the top of other ...