lozzeroooni
New Member
- Joined
- Feb 20, 2020
- Messages
- 12
- Office Version
- 365
- 2019
- Platform
- Windows
Hi there,
I'm trying (and struggling) to set up a poker table that will give an rank for each player and an average finish but for the player to be included, they need to have played a minimum of 3 games.
I've set it up at the moment so it provides an average finish and rank but player 'K' for example has only played 1 game (and won) so has a higher rank than someone who has done consistently well over 3 games.
Here's a sample:
Any help would be greatly appreciated!
I'm trying (and struggling) to set up a poker table that will give an rank for each player and an average finish but for the player to be included, they need to have played a minimum of 3 games.
I've set it up at the moment so it provides an average finish and rank but player 'K' for example has only played 1 game (and won) so has a higher rank than someone who has done consistently well over 3 games.
Here's a sample:
Player | Rank | Average Finish | Games Played | 27/03 (8 players) | 27/03 (6 players) | 3/4/2020 (12 players - 7 rebuys) |
A | 5 | 4.3 | 3 | 7 | 1 | 5 |
B | 3 | 2.3 | 3 | 2 | 2 | 3 |
C | 2 | 2.0 | 3 | 1 | 3 | 2 |
D | 6 | 5.3 | 3 | 4 | 6 | 6 |
E | 8 | 7.0 | 3 | 8 | 5 | 8 |
F | 7 | 6.5 | 2 | 3 | 10 | |
G | 8 | 7.0 | 3 | 6 | 4 | 11 |
H | 11 | 8.5 | 2 | 5 | 12 | |
I | 4 | 4.0 | 1 | 4 | ||
J | 12 | 9.0 | 1 | 9 | ||
K | 1 | 1.0 | 1 | 1 | ||
L | 8 | 7.0 | 1 | 7 |
Any help would be greatly appreciated!