MAX function for index match or vlookup

hi all.

I have need to find the max number from a list of numbers with a criteria. looks like this:

a | 1
a | 2
a | 3
b | 4
b | 3
b | 2

So the function need to get the max value for all rows where a. For example, the max of "a" would be 3.

So, I know that the MAX function would be involved, but I don't know how to get the function that would group all "a" rows together then find the max in that group.

any help please?

Hi Journeyman3000,

For excel 2010, the array formula below should work.

Requires Control+Shift+Enter

Please Login or Register  to view this content.

-DMG

Thanks so much. this works great.