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

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

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

Something like:

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

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

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

--

Vasant


"Ayato" wrote in message
.. .
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