Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |