vlookup using max
 

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

vlookup using max
 

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.

--
Biff
Microsoft Excel MVP


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

vlookup using max
 

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


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





Dear Mr Valko,

Thanks for your help,

Regards,

Are

vlookup using max
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Are" wrote in message
...


"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


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





Dear Mr Valko,

Thanks for your help,

Regards,

Are