How do i set up a workbook to............

[Danthevan]

Hello clever people !

I have set up a website for a youth football team. What i am trying to do is
set up a work book that can work out the league table for me, then just copy
and paste it into my web page.
Ideally i would like it to work out the teams position in the league, from
me entering the games won, lost etc , rather than having to change every cell
individually.

If anyone can help it would be much appreciated.

Many Thanks

 

[Norman Jones]

Hi Danthevan,

See:

http://www.xldynamic.com/source/xld.LeagueTable.html

 

[Domenic]

I'm not quite sure if this will do, but using the following table as a
example...


Code
-------------------
Team Wins Losses Ties Points Rank
TeamA 10 3 2 22 4
TeamB 8 5 2 18 5
TeamC 12 2 1 25 2
TeamD 10 2 3 23 3
TeamE 12 1 2 26
-------------------


F2, copied down:

=RANK(B2,$B$2:$B$6)+IF(COUNTIF($B$2:$B$6,B2)>1,MATCH(E2,LARGE(IF($B$2:$B$6=B2,$E$2:$E$6),ROW(INDIRECT("1:"&COUNTIF($B$2:$B$6,B2)))),0)-1,0)

...confirmed with CONTROL+SHIFT+ENTER. You'll notice that wher
there's a tie, the ranking is determined by points.

Hope this helps!