All Questions
Tagged with worksheet-function microsoft-excel
7,314
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
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
2
answers
147
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
14
views
sum cells based on corresponding values in a data set in excel
Can someone kindly help with the following please, I would like to calculate the sum for each person if it says yes in the columns with the corresponding number
Person
Car
House
Job
Holiday
Sum
1
...
0
votes
1
answer
19
views
How to sum values based on unique values in other column when filter is applied
I have the following problem. There are order numbers in column A which are duplicated due to a different products in column B. What I need is to sum order values in column C only for unique order ...
0
votes
1
answer
34
views
How do I lookup sheet names and create hyperlinks to sheets in a workbook?
I am managing a workbook with many sheets and I would like to make a separate sheet for navigation.
The sheets' names have a numeric prefix, like:
000-ATable
001-AnotherTable
002-YetAnotherTable
The ...
0
votes
0
answers
33
views
how to sum up using multiple criteria?
i am calculating sum of profits (column O) based on the list of comments as u can see from column V. this is working fine. now i want to add additional criteria where i want it to sum up for me based ...
0
votes
0
answers
43
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
0
votes
0
answers
54
views
Add total of Numbers from Multiple Sheets
I have 2 workbooks. One that one employee will use and one that another will use. On Workbook "A" they are scanning and logging when cars are brought into our garage. THey log the Car Number,...
0
votes
1
answer
38
views
How do I pull data into a new list separated by commas
What is a formula to pull the States of overlap in a list separated by commas like in this example?
iXcg.png
-1
votes
2
answers
44
views
What is the Excel formula to filter these three lists?
What I am trying to accomplish:
Source Data:
A
B
C
D
E
F
G
H
I
J
K
L
M
List A
30
0
0
14
0
0
9
0
0
17
0
0
6
List B
17
13
0
0
12
22
21
0
8
0
0
0
7
List C
31
0
0
5
42
1
0
0
0
0
0
0
41
Output:
List ...
1
vote
2
answers
178
views
Formula to return row pairs of data based on number in second row
In Excel, I have two rows of data.
In each column,
Row 1 contains a letter of the alphabet.
Row 2 contains a number associated with the letter above it.
How do I return the values from only those ...
-3
votes
1
answer
36
views
Is there function that compares two ranges and returns the number of cells that changed values
I have two ranges and I want to count how many values have changed between them. I am trying to find a function that compares the two ranges and returns the number of cells that change. I know I could ...
0
votes
1
answer
75
views
Formula to return employee codes from a lookup table of names and codes
In Excel, I have five employees each with a unique emploee code.
In column A I have hundreds of rows of these employee names and I want to return each name's corresponding code in column B.
In columns ...
0
votes
2
answers
45
views
Is there simpler than OFFSET in Excel to get a cell range?
Let's say you want a range of cells beginning at D3, of height given in cell A1 and width 2, then:
=OFFSET(D3, 0, 0, A1, 2)
works.
Is there something even simpler than OFFSET, like RANGE(D3, A1, 2)?