League table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to craete a league table that automatically list the highest score
first descending along with member name alongside.

Arranging the scores is easy, but I cannot get the names list to re-arrange
to tie in with scores.

Any ideas
 
Assuming names list in A1:A7
Score list in B1:B7

In C1: =LARGE($B$1:$B$7,ROWS($1:1))
In D1: =INDEX($A$1:$A$7,MATCH(C1,$B$1:$B$7,0))

Adjust to suit
 
Back
Top