# 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.

19,119
questions

**0**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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 ...