find the max and min numbers in a column that also end in a word in another column

[tonywatsonhelp]

Hi Everyone

I'm trying to find the max and min number in a column but i need it to have the last 6 letters in another column = "Excess" I say last 6 letter not last word as it can be "Legalexcess" or "Upperexcess" or just excess etc, )

the column i want the max and mins from is column AA
The Excess is in column H

prefer a formula for this if possible?

please help if you can

thanks

Tony

 

[jasonb75]

Note that this will not work with excel 2016 (or older)

=MAXIFS(AA,H,"*excess")

 

[tonywatsonhelp]

Wow,
Thats brilliant,
thank you for your help Jason
Tony