Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
8,213
questions
0
votes
2
answers
47
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
63
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
37
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
172
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
28
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
14
views
Excel - Create 'Next' after spill range
I may be reaching the extent of excel's capabilities without getting into VBA (out of my depth).
I need the "Product Collumn" (Collumn B) to automatically populate (Spill) the subsequent ...
0
votes
0
answers
47
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
50
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
0
answers
19
views
How to return unique, ordered data in Excel?
Last year I asked the following question. The formula has been working great. But I've been asked to provide some additional information that I can't quite figure out how to add.
My input data now ...
0
votes
0
answers
18
views
Is there a formula capable of building rows in google sheets? [migrated]
Not sure if this is possible or not, but essentially I need a formula that is capable of building rows in google-sheets.
My data is currently like this: Column A = Property Name, Column B = Routines. ...
0
votes
0
answers
19
views
How can I have a cumulative total from a table that changes daily?
I have a daily schedule of when people get breaks. I would like to capture that data in a second table. The Daily table is changed daily but I would like the information to be captured and added to ...
0
votes
1
answer
26
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
30
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 ...