vlookup using max

[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. 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.

 

[Are]

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.

Dear Mr Valko,

Thanks for your help,

Regards,

Are

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Dear Mr Valko,

Thanks for your help,

Regards,

Are