Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jack
Jack,
I think I mis-read what you wanted to do. Try this formula instead =INDEX(H2:H20,MATCH(MAX(IF(ISNUMBER(MATCH(G2:G20,{ "RST","ABC"},0)),E2:E20)), E2:E20,0)) which is an array formula, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jack
Bob,
Without assistance from people like you working with Excel would be like crossing on foot the Gobi desert. Happy new year! Jack. "Bob Phillips" schreef in bericht ... Jack, I think I mis-read what you wanted to do. Try this formula instead =INDEX(H2:H20,MATCH(MAX(IF(ISNUMBER(MATCH(G2:G20,{ "RST","ABC"},0)),E2:E20)), E2:E20,0)) which is an array formula, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Jack
Jack,
Sorry about the subject, don't know what happened there, but at least you found it. Happy New Year to you, and my many friends in the Netherlands. Bob "Jack Sons" wrote in message ... Bob, Without assistance from people like you working with Excel would be like crossing on foot the Gobi desert. Happy new year! Jack. "Bob Phillips" schreef in bericht ... Jack, I think I mis-read what you wanted to do. Try this formula instead =INDEX(H2:H20,MATCH(MAX(IF(ISNUMBER(MATCH(G2:G20,{ "RST","ABC"},0)),E2:E20)), E2:E20,0)) which is an array formula, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array in VBA | Excel Discussion (Misc queries) | |||
how do i simulate a king queen or jack playing card in excel assum | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
Changing cell value with arrows (?) | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |