All Questions
Tagged with microsoft-excel worksheet-function
7,324
questions
0
votes
1
answer
19
views
Having a Hard Time Using Microsoft Excel If Function
I have been working on a simple tracking database and I'm having a hard time using the IF function (or if this is even the right function to use for my problem). I want to create an ID number for the ...
0
votes
2
answers
49
views
Split cell into three columns without losing leading zero
I have a column with a phone numbers without hyphens. I am using text to columns to latter recombine the numbers with hyphens but it's dropping leading zeros in the last cell.
You are seeing leading ...
0
votes
3
answers
64
views
calculating the average of column that is not a number
So I have 2 sheet, the first one contains student's name, subject, and their grade.
Sheet1 :
A
B
C
Mark
Math
A
Dave
Physic
C
Carol
Math
B
Dave
P.E
B
Carol
Physic
A
Mark
Physic
A
The second one ...
-1
votes
1
answer
38
views
How to count cells that are within specified tolerance with Excel?
I am trying to count the number of cells that are within a certain tolerance using =COUNTIF(). The +/- tolerances are in different columns and I need to apply this formula to multiple rows that have ...
1
vote
1
answer
18
views
Calculate duration between 2 milestones based on criteria
Given the following problem: An ice truck is rented for a certain duration with a start date "x" and an end date "y".
Example:
rental start date in cell b1 = 27/05/2025
rental end ...
2
votes
2
answers
173
views
Excel: Sum all quantities of unique items across all sheets
I have data spread across several sheets that includes (amongst other things) a part number and a quantity associated with that part. The part number and quantity appears many times in each sheet. I ...
1
vote
1
answer
30
views
Excel: How to select a chart's data range using a corresponding value in another cell?
Let's say a DataSheet has the following data that is subject to change, including date headers. The number of columns is always the same. (Top left cell is A1.)
Name
Dec 1
Dec 2
Dec 3
Dec 4
Dec 5
...
...
0
votes
0
answers
29
views
NOT WORKING: Using IFS Formula when reference cell is a result of a vlookup to pivot table. Only returns N/A
I am trying to use the IFS() formula where the reference cell is the result of a VLOOKUP() (the VLOOKUP() is looking at a Pivot Table.)
It is not working, even when I've tried using (value(cell))
...
0
votes
0
answers
48
views
Looking to replace Indirect function to pull dynamic ranges
I've created a dynamic range formula which shows as below:
=CONCATENATE("AC SalesRawData!",SUBSTITUTE(ADDRESS(1,C1,4),"1",""),":",SUBSTITUTE(ADDRESS(1,C2,4),&...
1
vote
1
answer
52
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
27
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
31
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
28
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
26
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
157
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 ...