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
|