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

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

Guest

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
 
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!
 
Back
Top