MAXIFS equivalent using 3 or more variables

[Quick]

Tryin to solve this MAXIFS with many variables on the "IFs" 

[Luke_C · Accepted solution]

@Quick 

I think you can achieve this with a summarize to find the max followed by a join back to the main data. See attached and let me know if this is working as expected. At first glance it seems to reconcile.