League table

[Chas Fudge]

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

 

[Teethless mama]

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