need formula help
 

I'm trying to get the names of the players to match up with there perspective
scores which change every week the scores in column c are =large formulas
this puts them in order from 1st to 5th if anyone has a sugestion or a
different formula that would do both functions at the same time it would help
a lot.
NEW HAMPSHIRE2
DOVER2
KANSAS
TALLADEGA2
LOWE'S2
MARTINSVILLE2
ATLANTA2
TEXAS2
PHOENIX2
HOMESTEAD
TOTAL 3 2 7 4 8
PLAYERS Ken M Vic B Mark A Jonus U Rich B

PLAYERS STANDINGS PLACE SCORE
Ken M 1st 2
Vic B 2nd 3
Mark A 3rd 4
Jonus U 4th 7
Rich B 5th 8


thanks muck