Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
27
questions
1
vote
0
answers
13
views
Excel linked data formula giving different solutions after updating to new computer
As the title states, my work computer has been updated to new system (Windows 11) and I've tried my best to arrange all the files and folders in the same way they were previously, but am still running ...
0
votes
0
answers
9
views
Formula Name Error converting address list to address block list
6240 Grand Blvd; Grace Church to 6200 Block Grand Blvd.; Grace Church
To convert addresses to block listed addresses I am trying to use this four step formula:
=LEFT(A2,(FIND(" ",A2,1)-1)) ...
0
votes
2
answers
131
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
13
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
17
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
32
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
4
views
Google sheet ROI formula not working [migrated]
My google sheet formula isn't working as intended.
In order to calculate the ROI of an event im making I use different stats and make a big calculation of points at the ROI collumn [![Presentation of ...
0
votes
1
answer
33
views
Count working days between dates
I am seeking a formula that can calculate the number of weekdays between two specified dates, or if the end date is not provided, calculate the number of weekdays from the start date to the current ...
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,...
-1
votes
1
answer
19
views
regex to find non-price consecutive digits not immediately after certain word for Apple Numbers
0
How to find invoice number from different companies which may have different order of invoice number, unit cost and total cost?
Following is specific example of a company XYZ which I need to get ...
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
177
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 ...