max scores

[Guest]

tom 100
sue 200
bill 300
with a list of scores i can get 1st 2nd 3rd on down, and I can put the name
with the max score. How can I get the name with the 2nd, 3rd on down.PLS> Help

 

[Barb Reinhardt]

Let's say you have this data listed in A1:B3

This will work if you don't have more than one person getting the same
score.

Highest score
=INDEX(A$1:A$3,MATCH(LARGE(B$1:B$3,1),B$1:B$3,0),0)

2nd highest score
=INDEX(A$1:A$3,MATCH(LARGE(B$1:B$3,2),B$1:B$3,0),0)

3rd highest score
=INDEX(A$1:A$3,MATCH(LARGE(B$1:B$3,2),B$1:B$3,0),0)

 

[Bill Kuunders]

Select both columns
go to data sort and sort by the scores column
the names will follow suit.

Greetings from New Zealand
Bill K