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. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
26,634 questions
0
votes
0
answers
29
views
Defining a named region of multiple areas, which expands correctly within Conditional Formatting
I have a sheet where pairs of columns are logically grouped, such that $B:$B contains a list of names, and $C:$X are the logical pairs ($C:$D, $E:$F,...). There is also a header row $1:$1, where the ...
- 757
1
vote
0
answers
43
views
Conditional Formatting - use table for fill color?
I have a table that could have any number of "Regions", almost in any order. I'm wondering if there's a way to use some sort of "lookup table" that looks to a region, then fills ...
- 2,976
0
votes
0
answers
34
views
How do I update my Excel spreadsheet after I'm emailed a new table?
Every month, I am emailed a spreadsheet. This spreadsheet is a list of people. Sometimes new people are added, or old people are removed.
I then use the list, and add extra fields so I can make notes ...
- 191
0
votes
0
answers
27
views
I'd like to make a status chart that looks like a proportional heat map. Can this be done in Excel or PPT?
Here is an example of the type of chart I'm trying to make. I'd like to visually show the count of studies in a given status, and have it be proportional so I can quickly see potential areas of focus. ...
- 1
-2
votes
1
answer
47
views
VLOOKUP that preserves general format
How can I use VLOOKUP and preserve the data if both source and target cells have "General" format? It does not work as expected, because if the source cell is blank then the target cell ...
- 27
0
votes
2
answers
138
views
Excel: SUMIFS with a daterange
I have the following datasets:
TableA
start_date
end_date
Ref
days
01.11.2025
30.11.2025
X
=SUMIFS(TableB_workdays, TableB_Ref, =Ref, TableB_start_date, >= start_date, TableB_end_date >= ...
- 21
-3
votes
1
answer
106
views
Matching and confirming combination of data from different columns, where data could be exact or an approximate match
I have a case, I am not sure if its possible to solve, but I will appreciate any help or some sort of workaround. I need to compare combination of data from columns A+B with combination of data from ...
- 71
0
votes
1
answer
64
views
Vlookup between two sheets
There are two sheets in Excel as shown below. I want to perform a VLOOKUP operation. However, it did not work correctly with upper and lower case letters.
What I want to do: It will search for the ...
- 487
0
votes
1
answer
60
views
Dependent drop-down in Excel tables
I've seen multiple related questions but non of them solve my issue. Please close the ticket if it is indeed a duplicate.
I have three sheets (see details below). I want to have dependant drop-downs ...
- 355
0
votes
0
answers
47
views
Updating an Excel sheet that has an external data link
I have an Excel sheet where some columns are from an external sheet, with an underlying query, and some columns are for this sheet only, e.g. very simply
A
B
C
1
Name
Cost
2
NameA
10
3
NameB
5
4
NameC
...
- 449
0
votes
2
answers
59
views
Excel - cannot use embedded countif but works from cell reference
I've got a scenario where I want to review a row from a table, take the data on left of each string and then count them.
My plan was to refrence the table column, use left to get the first three ...
- 1,333
0
votes
2
answers
46
views
Add value from a another cell, to formula cell, depending on values of other cells withing the same row
Sorry for the confusing title! I have an Excel that looks like this:
The cells labeled 'pending' are actually dropdowns with three values: Pending, Done, and Not Done. What I want to happen is that, ...
- 103
2
votes
1
answer
72
views
Formatting Excel number to show Accounting dash with in my current formula [closed]
Regarding this post: Format a number with optional decimal places in Excel
The solutions works perfectly for me, except I wish to have all results that are ZERO turned into the Accounting " - &...
- 21
4
votes
2
answers
820
views
How do I stop Excel from changing cell range when moving data around my spreadsheet?
I have a spreadsheet of containers that are constantly moved around to various locations on my site which we track on this spreadsheet.
I have formulas to count the number of containers in each column ...
- 41
0
votes
1
answer
108
views
How to import into Excel a UTF-8 encoded CSV file containing line breaks within fields?
Importing CSV files containing line breaks within fields is tricky and the usual import methods as described for Excel do not work. Only opening a file directly with "File -> Open..." ...
