Forum Discussion
Solved
Formula for: Filter an array based on a referenced value, then select largest value in other column
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...
- starting in Excel 2019 there is MAXIFS() function that can do that. What version of Excel do you have?
starting in Excel 2019 there is MAXIFS() function that can do that. What version of Excel do you have?
- Works! Thank you
Just in case, couple of more options
=AGGREGATE(14,6, range/condition1/condition2,1)and
=MAX( FILTER( range,condition1*condition2 ) )- Awesome thanks 🙂
