How to combine Vlookup and MAX ()????

[Ayato]

Hello @ll,

I am look for a way (code?) to indetify a MAX value for a typex or y, in a 2
column table. Something like including a vlookup in a MAX() function (?)

So I have :

A 2
A 1
A 5
B 6 and nead a furmula (or to code) to calculate the
MAX for A and B
B 1
A 7 A = MAX(?)
A 2 B = MAX(?)
B 3


Please advise,
regards,
Ayato

 

[Vasant Nanavati]

Something like:

=MAX((A1:A12="A")*(B1:B12))

=MAX((A1:A12="B")*(B1:B12))

entered as array formulas with <Ctrl> <Shift> <Enter>.