Creating League tables

[firephoenix]

I am trying to use excel to create an automatically updating league table for a league I have set up. I used

=RANK(S2,$S2:$S18)

in order to rank the players, then used

=IF(ROW()-ROW(V$3)+1<=$U$1,INDEX($A:$A,MATCH(ROW()-ROW(V$3)+1,$T:$T,0)),"")

to order them in the table, this causes problems when two players have the same points. So I then tried changing the RANK statement (with some advice to

=RANK(S3,$S$3:$S$22)+IF(COUNTIF($S$3:$S$22,S3)>1,MATCH(R3,LARGE(IF($S$3:$S$22=S3,$R$3:$R$22),ROW(IN DIRECT("1:"&COUNTIF($S$3:$S$22,S3)))),0)-1)

to take into account another column when points are equal, unfortunately this doesn't seem to work either giving a #NAME error.

Thank you for any assistance with this.

[cycling-rod]

There's a long thread on league tables here: http://www.excelforum.com/showthread.php?t=348528 Maybe it will help to read through the thread? You could also try a Google search for: league table excel, you may find one ready-made that's suitable.