I have a table of data that I want to find a MAX value for.
The challenge is filtering the values I care about.
Basically, I want the MAX from Column D when:
- Column A = 'VIC'
- Column B = 'CBD'
- Column C = 'Leaderboard'
Is there a MAXIFS equivalent?
I have a table of data that I want to find a MAX value for.
The challenge is filtering the values I care about.
Basically, I want the MAX from Column D when:
Is there a MAXIFS equivalent?
There's no built in function for this, but you can achieve what you want with an array formula.
You enter it as:
=MAX(IF(A1:A20="VIC",IF(B1:B20="CBD",IF(C1:C20="Leaderboard",D1:D20))))
and then commit it using CTRL+SHIFT+ENTER rather than just ENTER. This will add {} around the formula and turn it into an array formula