If anyone could help with this I would be so grateful
I need to create an excel points template for a poker league.
I need to create the sheet as following:
1. There can be an infinite amount of players (let's say 200 for probability purposes)
2. 1st place winner - Player 1 = 10 times the amount of players (in this hypothetical its 200) so Player 1's points are 10 times 200
2. 2nd place winner - Player 2 = 9 times the amount of players (or 200)
3. 3rd place winner Player 3 = 8 times the amount of players (or 200)
etc. etc. etc.
4. 10th place winner Player 10 = 1 times 200
5. 11th place winner Player 11 = .5 times 200
Player 11 through Player 20 ALL get points of .5 times 200
Player 21 through Player 200 (or however many players, which again, in this hypothetical is 200) will all get 0 points
If anyone could help me out with this or point me in the right direction please let me know, I sincerely XXXXX XXXXX!
my personal email [email protected]