Use the value of one cell to return another

T

Thadar

Hello all,

I am trying to list the top 4 people based on a score. For
hypothetical lets just say that this is my table: Two columns A and B

A B

Frank 7
Cindy 12
John 6
Sam 3

Now, I would like column C to return the NAME of the people(all o
them) with the person having the highest score listed first(C1 would b
first place, C2 second, etc). How would this be done? Thank you fo
your time
 
B

Bob Umlas

in C1:
=INDEX($A$1:$A$100,MATCH(LARGE(B$1:B$100,ROW()),B$1:B$100,0))
and fill down

Bob Umlas
Excel MVP
 
B

Bernard Liengme

Assuming your data is in A1:B4 use
=INDEX($A$1:$A$4,MATCH(LARGE($B$1:$B$4,ROW(A1)),$B$1:$B$4,0))
in C1 and copy down to C4
If the data is elsewhere, change $A$1:$A$4 and $B1:$B4 as needed but leave
ROW(A1) as is - it gives us LARGE(range,1) which becomes LARGE(range,2) when
copied down a row
best wishes
 
Top