League table help for a novice

[nirishlad645]

Hi all,

I am trying to cure the boredom of being away from home by starting a league table. What I intend to do is every week pick 10 random teams and see if people can predict the correct score. If for example they manage to guess the correct score they will get 3 points, if they choose Man Utd v Liverpool and guess 4-1 to Liverpool, if the score comes out as 2-0 to liverpool they will get 1 point for a win.

Then i want to have a league table to display at the end of the days football to see who is winning.

They reason i want to use excel is I have about 50 people playing this game and if i can update this automatically I will be a very happy man.

Every person puts 2 bucks in for the pleasure, whoever is at the top of the league wins some money. This equals big moral boost!!!


I hope someone can help me!


Regards


Davy

[nirishlad645]

Here is my finished product - feel free to copy