All Questions
58
questions
1
vote
2
answers
53
views
Counting elements based on three criteria located in two columns
I wanted to ask you if there is a way to perform a count by applying formulas directly, without having to resort to the filter option, through the COUNTIF or COUNTIFS function.
From two criteria found ...
1
vote
2
answers
2k
views
Excel: Split a string on a delimiter and determine the length of the resulting array
I have an Excel sheet including columns like this:
| 143 | 423 | | | 423;234 | 134;234;143 | =SOME_FORMULA() |
The data have the following characteristics:
Although numeric, they should be ...
- 705
1
vote
1
answer
378
views
=DATEVALUE() behaving different in Excel 365 online and Excel 365 local
I noticed that =DATEVALUE() behaves different in the online version of Excel 365 (i.e. it does not work) than in the local version of Excel 365 on my PC. Below are two screenshots of the two Excel ...
- 107
1
vote
2
answers
304
views
Excel 365: Array formula based on value above (compounding)
I am trying to perform an operation in a cell based on the value of the cell above it. Doing this in the "normal" Excel way is easy enough. However, I am playing with the array functionality ...
- 281
1
vote
1
answer
921
views
How to return the value of one cell based on the max of multiple ranges of other cells in excel?
I am a bit new to excel and have a spreadsheet where I am trying to use the MAX of a range of cells in order to return the name of the row that that MAX belongs to. So, I have a cell returning the MAX ...
- 19
1
vote
1
answer
612
views
Getting unique items from comma separated lists in Excel
I have the following setup (which is shared by a number of users through office 365 and changed frequently):
I need to collect all unique items from a number of comma-separated lists in a range and ...
- 13
1
vote
1
answer
2k
views
Filter function with IF statement in 1st parameter to perform fill down multiplication OR division
Link to my previous related question for more background if needed: Transpose unique rows to columns while IF statement conditions are met but do not consolidate
My table headers start on row 20 ...
- 45
1
vote
1
answer
213
views
Name the first item from a list that is not in another list
I am working with a list of articles in one spreadsheet files as the data source. The data is split into a source reference code in columns A to E, the title of the article in column F and the author ...
- 113
1
vote
1
answer
269
views
autofill a reference of a column to a row in steps
I have the formula =IF(Jan!$L6="w",Jan!$L6,"") in the cell A2.
in the cell right next (B2) to it I'd like to have the formula 3 rows further down so
=IF(Jan!$L9="w",Jan!$L9,"") and then in C2 ...
- 115
1
vote
2
answers
72
views
Please help me stop Excel 365 enterprise from changing my text formatted cells into formulas
I have a spreadsheet where I need to use strings that contain a couple of dash/ minus ( - ) signs in cells, but it will not stop truing to recognize them as formulas! I have already formatted the ...
- 11
1
vote
3
answers
309
views
Microsoft Excel: Use OR Logic and multiple ranges with COUNTIF
I am analysing some form responses and want to count if someone has put a specific answer in a range of different boxes. I have attached an example to explain the logic.
When filling out address ...
- 13
1
vote
1
answer
232
views
formulas in another column that reference spill range not updating when sheet is recalculated
I have a a column that is a spill range that uses the filter and sort_by formulas. This spill range is dynamic and I have an IF statement that references the spill range but upon recalculation of the ...
- 11
1
vote
0
answers
64
views
Excel - Select range depending on cell
I want to select a row range, which I've been doing manually until now. However as data grows, I've tried to select the row according to the relative worksheet, but don't know how to. Here's an ...
- 111
1
vote
0
answers
44
views
Last filled row Function behaves strangely based on column it's in
Function is acting very strange depending on column it's in.
Data start at row 7 (headers in row 6)
Column A has item name B Max Qty. C and D have simple functions and everything afterwards is the ...
- 11
0
votes
3
answers
432
views
Excel - Filter rows based on starting string, read number from filtered rows and perform arithmetic operation to generate column summary
I am having a Project and resource allocation report. I need help in generating the formula to display summary in the bottom section of my report.
Here're the specifications of my report:
Column A ...
- 105