Nov 03 2021 02:42 PM
Hello,
I am looking for some sort of "LARGEIF" formula. Here is my dataset. Column D represents expected results from the formula I need.
In words, I would put the following formula in cell D2:
- For entire dataset:
- Consider only rows that have column A = cell A2
- Then, consider only rows that have column B = cell B2. Mockup result using actual filters:
- Then, using the resulting filtered dataset, get the largest value in column C. The largest value is 7:
- copy down this formula in column D to get the following results:
Can this be achieved?
Thanks
Nov 03 2021 02:49 PM
SolutionNov 04 2021 07:53 AM
Nov 04 2021 10:09 AM
Just in case, couple of more options
=AGGREGATE(14,6, range/condition1/condition2,1)
and
=MAX( FILTER( range,condition1*condition2 ) )
Nov 04 2021 11:04 AM
Nov 03 2021 02:49 PM
Solution