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
|