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?
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 🙂