I am trying to create a soccer league table for a mini-league i am hosting.
I have started on my table but because my knowledge on excel is poor i have only got so far. I am wanting my spreadsheet to let me enter a result and for it to automatically work it out on the leaugue table. I have tried using IF functions but havnt go far, probably because i am entering in wrong formulas etc. Does anyone have any idea how i could do this? You can get a copy of what i have done so far here:
http://www.scribd.com/doc/12971041/My-League-Table
Thanks.
I have started on my table but because my knowledge on excel is poor i have only got so far. I am wanting my spreadsheet to let me enter a result and for it to automatically work it out on the leaugue table. I have tried using IF functions but havnt go far, probably because i am entering in wrong formulas etc. Does anyone have any idea how i could do this? You can get a copy of what i have done so far here:
http://www.scribd.com/doc/12971041/My-League-Table
Thanks.