Thanks for taking interest, here goes, hope it reads well.
I have 25 teams, of which consists of 11 players which workmates have chosen from the Sun Dreamteam list.
When the football starts and each team player plays, he will be awarded either of the following:
Awarded seven or more in Sun Sport's player ratings 3
Star Man in Sun Sport's player ratings 5
Goal Scored 5
Top in Position in News of the World Dream Team of the day 8
The remaining seven players in News of the World Dream Team of the day (not including Top in Position) 2
Scoring three or more goals per game 5
Clean Sheet (keeper/defender) 5
Clean Sheet (midfielder) 2
Conceded more than one goal (keeper/defender) -1 per goal
Penalty save (keeper) 3
Booking -1
Sent off -3 in total
Season's top individual points scorer bonus 20
Now I want to set up a program so that when I enter any of the above for each player it shows up who is 1st/2nd/3rd and so on.
Does this help.
Many Thanks
Pugg