Simple League Table

[Zippy2005]

Can anyone tell what the best function is to use for a simple league table.

The table only has 3 people in it and I just want it to sort the automatically in to order.

Cheers....

[Domenic]

Assuming that Column A contains the 'Player' name, Column B contains the 'Score/Points', and the first row contains your headers/labels...

D2, copied down and over to the next column:

=INDEX(A$2:A$10,MATCH(LARGE($B$2:$B$10-ROW($B$2:$B$10)/10^10,ROWS(D$2:D2)),$B$2:$B$10-ROW($B$2:$B$10)/10^10,0))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!