Thread: top3 selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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