Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to combine Vlookup and MAX ()????
Hello @ll,
I am look for a way (code?) to indetify a MAX value for a typex or y, in a 2 column table. Something like including a vlookup in a MAX() function (?) So I have : A 2 A 1 A 5 B 6 and nead a furmula (or to code) to calculate the MAX for A and B B 1 A 7 A = MAX(?) A 2 B = MAX(?) B 3 Please advise, regards, Ayato |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to combine Vlookup and MAX ()????
Something like:
=MAX((A1:A12="A")*(B1:B12)) =MAX((A1:A12="B")*(B1:B12)) entered as array formulas with <Ctrl <Shift <Enter. -- Vasant "Ayato" wrote in message .. . Hello @ll, I am look for a way (code?) to indetify a MAX value for a typex or y, in a 2 column table. Something like including a vlookup in a MAX() function (?) So I have : A 2 A 1 A 5 B 6 and nead a furmula (or to code) to calculate the MAX for A and B B 1 A 7 A = MAX(?) A 2 B = MAX(?) B 3 Please advise, regards, Ayato |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup and combine all references | Excel Discussion (Misc queries) | |||
Combine Vlookup and If? | Excel Discussion (Misc queries) | |||
Vlookup and Hlookup Combine? | Excel Worksheet Functions | |||
Combine Vlookup and Hlookup | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) |