vlookup using max

A

Are

Dear Masters,

How to get value of max from array with some condition?
for example I have data :

A 3
B 3
A 5
C 2

I want result :

A 5
B 3
C 2

thanks in advance
 
T

T. Valko

Try this array formula** :

=MAX(IF(A1:A4="A",B1:B4))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
A

Are

T. Valko said:
Try this array formula** :

=MAX(IF(A1:A4="A",B1:B4))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
Click to expand...

Dear Mr Valko,

Thanks for your help,

Regards,

Are
 
Top