Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
top3 selection
If I get the top3 from a list but I need the info from the list next to it -
how can I do that |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
top3 selection
Say your number list is in A1 to A20, and the data you want returned is in
B1 to B20. Enter this formula in say C1, and copy down to C3, to get the corresponding data from Column B in the same row as the 3 largest values in Column A: =INDEX(B$1:B$20,MATCH(LARGE(A$1:A$20,ROWS($1:1)),A $1:A$20,0)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ekkeindoha" wrote in message ... If I get the top3 from a list but I need the info from the list next to it - how can I do that |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Row Selection | Excel Discussion (Misc queries) | |||
selection in VBA | Excel Discussion (Misc queries) | |||
Changing Selection for the "Center Across Selection" alignment | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |