Forum Discussion
Find the maximum value in a column based on results in a different column
Hi all, I was hoping for some help with a function I've been trying to figure out. I'm trying to find the highest value in column A out of all of the rows that correspond to a specific value in c...
Hello Henry
Use MAXIFS().
Oh man, it's so simple! Thanks so much, I was obviously going down a very elaborate path!
LARGE() had to be used until Excel 2007.
As of Excel 2010 we got AGGREGATE().
As of Excel 2016 we got MAXIFS().
And there is always Pivot and Power Query.
