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

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 )

"Cricket" wrote in message
...
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

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

Greetings from New Zealand
Bill K
"Cricket" wrote in message
...
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