All Questions
Tagged with microsoft-excel worksheet-function
7,317
questions
1
vote
0
answers
5
views
Nested If's with Vlookups not working in Excel
I have an MS Excel 365 (with current patches) spreadsheet that tracks mileage and tolls to various locations. I am trying to build in logic that won't populate mileage and tolls if I have 2 entries ...
0
votes
1
answer
18
views
Excel Formula According to the attached table, the rank has been found according to Achieved %, in which some salesman does not have target
According to the attached table, the rank has been found according to Achieved %, in which some salesman does not have target.
The data in this table should come in a new table according to rank order ...
0
votes
0
answers
21
views
How do I get rid of extra space in cell when using Text Wrap in Excel for Mac 2016?
I am using Excel to make a table with several columns with word wrapped text. When using auto cell height there is some extra space at the bottom of each cell - successively larger space for every ...
0
votes
1
answer
19
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
2
answers
22
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
151
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
35
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
44
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
180
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 ...