So in column A I have a name and in column B I have a score. In column C I would like a name and in column D I would like the score but the data needs to be sorted from High score to low score in column C and D with the appropriate name corresponding with the appropriate score.
I currently have the following formula that does part of the job.
=INDEX(A$1:A$400,MATCH(LARGE($B$1:$B$400,ROWS($1:1)),$B$1:$B$400,0)) in column C
=INDEX(B$1:B$400,MATCH(LARGE($B$1:$B$400,ROWS($1:1)),$B$1:$B$400,0)) in column D
This works unless there is a duplicate score. Then the formula returns the correct score but the name is returned for the first person who recieved that score. Any ideas on how to make the function return the unique name for duplicate scores?
Thanks in advance
Bookmarks