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,104
questions
0
votes
1
answer
16
views
IF cell is BLANK then VLOOKUP multiple criteria
I need help with excel formula. Can someone help me to solve this formula as it show FALSE for the blank cell
=IFERROR(IF(C12="Route Stage",VLOOKUP(D12,'Route Stages'!A:B,2,0),
IF(...
0
votes
1
answer
9
views
How to add a cell reference to Date Filter in Excel Pivot Tables
I have a date in cell C3, I want the Pivot table to only show expenses from that day. I tried entering the cell reference in this field to create a custom filter but it does not work. I also tried ...
-2
votes
0
answers
22
views
How to make this macro work with a date?
I've attempted to implement the macro written in the answers here:
Filter a table using information in cells outside of the table
But it doesn't seem to work for dates. I've got a column set to short ...
0
votes
1
answer
16
views
Creating a new column containing time in months based on specific conditions
I am trying to prepare an Excel file for analysis, but I can't seem to figure out how to solve the issue below.
The data involves a study in which participatns are followed for 5 years (even though ...
0
votes
1
answer
24
views
I need to create a percentage from yes or no dropdown answers
I'm very new to Excel and I'm trying to create an audit form, I've gotten the dropdown menu down.
Now I'm trying to create a score based on the yes or no answers. Each page has a specific amount of ...
0
votes
1
answer
26
views
Excel Parent-Child Array to identify and move children not working?
I use Excel 2019 on Windows.
I am trying to create a parent-child array that iterates through each row in the worksheet "Data".
The parent rows are identified where the value in column B ...
0
votes
0
answers
21
views
Can't get Grand Average in place of Grand Total in Pivot Table
My question is exactly the same as this one, but, for some reason I don't get, the answer doesn't work (or I don't read it right). Maybe something changed since then.
Let's say I have this. I get a ...
2
votes
1
answer
78
views
Loop over excel cells using for loop when cells are selected using CTRL
I am trying to loop over cells which are not selected in sequence, rather they are selected using mouse and CTRL.
When I use for each loop, then it works, but when I try for next then the result is ...
2
votes
2
answers
63
views
Excel HSTACK multiple arrays where an array may be empty
I want to abut multiple dynamically sized tables to each other where any one of the tables may be empty.
For example, say I have the following:
where A3 has the following formula:
=LET(
a, ...
0
votes
0
answers
29
views
VBA timer stops running when using another Excel workbook
I'm using the following VBA script for a countdown timer in Excel. It works well, except that the timer stops running when I switch to another Excel workbook - is there a way to keep it running in the ...
0
votes
2
answers
31
views
How to match a number in a column to make sure its in another column
[excel][1]
What formula do i use to make sure the number in column B exists in any row within column A ?!
|----------------------------------------------------------------|---------------|------------...
0
votes
1
answer
34
views
In a pivot table - how to summarize by specific value
Here is a table:
I want to create a pivot table that will show me for each name, how much percent of "A" the name have, for this example:
Dan 100%
Ron 40%
Dafna 14.29%
Can you explain me ...
0
votes
0
answers
29
views
Password protected Excel file on usb drive file behaving strangely when clicked
Nothing unusual at first glance - a password-protected Excel file on a usb stick. Previously, put the stick in the usb port, double-click the file and enter the password to work on the file.
Now ...
0
votes
2
answers
148
views
Dynamic Array - How to Conditionally Generate Sums?
I have a formula that's meant to iterate through a dynamic range, generate cumulative rows (the #/# in "Tally" represents a number of pieces and a length in ft.) and stack them into a new ...
0
votes
1
answer
34
views
Filter function for column with values only
I have a master database that lists the company with associated products and the clinical trial phase the product is in for different diseases. I am trying to only pull in columns that have values in ...