Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
2,598
questions with no upvoted or accepted answers
-2
votes
1
answer
51
views
How would I go about several contract values among various monthly start and end dates in Excel? Would like to use one dynamic formula if possible
How would I go about several contract values among various monthly start and end dates in Excel? Would like to use one dynamic formula if possible
I've tried playing around with it and have come up ...
-2
votes
1
answer
442
views
Counting the number of cells in a formula in Excel
I’m trying to determine a way to count the number of cell locations in a given formula.
For example, a cell (let’s say a1) contains the following: =c1+d3+f11+g5.
In a different cell (let’s say a2) the ...
-2
votes
2
answers
54
views
How to use Address function to write in the found cell? Microsoft Excel
I am trying to find a specific cell based on variable data. Currently, I'm using the "address" function to give the name of the cell, in this case Q10, and then filling it manually. Is there ...
-2
votes
1
answer
27
views
Need Formula of transaction
Cell A7 will need to charge $250, after Cell C3 hit $16,000. So any deals before the Cell C3 reaches $16,000 the Cell A7 will not charge the $250.
-2
votes
1
answer
837
views
How to sum last N rows in a column?
I have the following setup:
I need to:
Sum last n values in column B (excluding empty values, in this example sum of the last 2 values would be 8).
Return corresponding value from column A on the ...
-2
votes
1
answer
98
views
Find value in column, if present AND has different last digit, return text
I have to check If the material number is the correct variant. To do so, I have to compare it to the New Version list. If in the New Version the 10 digit match and the last digit is "2", BUT ...
-2
votes
1
answer
71
views
Writing an Excel Spreadsheet Formula
I need an Excel formula that will find the most efficient combination of products based on the value of a single cell.
e.g., I have a product list as follows: 400 / 220 / 150 / 110 / 72 / 60.
I need a ...
-2
votes
2
answers
686
views
Trying to unwrap two numerical columns into multiple columns
maybe anyone can help me out once again. I have 2 columns with numbers. I need an excel formula (filter??) that for all Ref values only the corresponding output values are placed in separate columns. ...
-2
votes
1
answer
49
views
How to retrieve the last data from non adjacent Excel columns and display it in a cell
Spreadsheet
Dear gurus,
I'm trying to create a mortgage simulator with Excel. As part of the spreadsheet, I decided to have a small section showing the current mortgage situation based on the ...
-2
votes
1
answer
145
views
Calculating total hours worked
Calculate the total hours worked on the first day, which is equal to the difference between cell F6 and cell E6 multiplied by 24. What is the formula?
-2
votes
1
answer
47
views
Excel table conversion help needed
Here is the current table:
I would like it to look like this:
As you can see in the original table, some people don't have data (paid up) for the categories of "rent" "late", "utilities", etc.
I ...
-2
votes
1
answer
346
views
Excel - Show if a cell (in the same column) has a value below it, not a blank
I need some help please, I'm trying to save time as I'm working with 100k+ rows.
I'm trying to find a way of finding out when there is information on 2 consecutive cells, one below the other. I've ...
-2
votes
1
answer
74
views
Excel formula is parsed but not evaluated
As can be seen from the screenshot I have entered what seems to be a valid formula (also see this: ) . However excel just prints the formula and not the result in that cell.
=SUM(+C50:C51)
What ...
-2
votes
1
answer
74
views
Merging duplicates and adding differences without using VBA
So I have a data set (I will just write an example below) that I need to merge duplicates and add differences onto the same line. Also with that I need to take a column and use its values a new header ...
-2
votes
1
answer
102
views
How to remove duplicated entries, and only keeping one entry per user per course
Needed help here!
Here, for example, the title (the title of a course), required date (the date they required to retake the course), and the completion date (the completion dates that a employee ...