Not sure if anyone can help here, but i seem to be going round in circles here and getting nowhere fast
What i'm looking at is setting up a poker league that runs for the whole of the year, around 46-48 games in the year.
So i'm working on a excel (2007) leaderboard that works all this out for me.
BUT
Only there top 20 scores will count towards the leader board
I have sheet 1 setup with all the weeks and the names of the players, so i can enter this information as we go, and on sheet 2 i have a simple table with player name, games played, average points & total points
What i need is working formula's for
1 - games played
2 - average score (based on there top 20 score's)
3 - total points (working from just there top 20 results)
If it was a simple league with all the points being counted it would be easy, but i need to make it there best 20 scores out of all the games they play, due to the league running for a year and ppl missing games, for holidays & other occassions
If anyone can help it would be most appreciated and can either email me direct at whirlers@blueyonder.co.uk or on here
Thx
Graham