JSLockwood
New Member
- Joined
- Aug 12, 2018
- Messages
- 4
Hi guys,
Can anybody help me with a formula
<tbody>
</tbody>
Basically, these are poker tournament results. In this specific type of tournament, you randomly pick between 3 different prizes when you win.
I want to generate a formula that gives me the % time I have picked the "top" "middle" and "lowest" prize (to see any variance from the expected 1/3 on each). I want this individually for each of the different buy-in amounts, as well as as a whole.
So I need a formula that does the following:
% Top Prize Picked (for $15 buy-in):
When 'Column A' = 15 and 'Column I' = 1, count the amount of times Column D matches Column J (divided by when Column A = 15 and Column I = 1)
Thanks in advance
Can anybody help me with a formula
A | B | C | D | E | F | G | H | I | J | K |
Buy-In | Players | Places Paid | 1st(1) | 1st(2) | 1st(3) | 2nd | 3rd | Pos | Prize | Profit /Loss |
30 | 5 | 2 | 150 | 50 | 50 | 30 | 0 | 5 | 0 | -30 |
15 | 4 | 1 | 125 | 20 | 20 | 0 | 0 | 1 | 20 | 5 |
15 | 8 | 2 | 90 | 40 | 20 | 25 | 0 | 4 | 0 | -15 |
15 | 6 | 2 | 55 | 35 | 30 | 20 | 0 | 1 | 30 | 15 |
15 | 6 | 2 | 145 | 35 | 30 | 35 | 0 | 2 | 35 | 20 |
30 | 4 | 1 | 70 | 70 | 40 | 0 | 0 | 1 | 70 | 40 |
15 | 3 | 1 | 40 | 30 | 20 | 0 | 0 | 1 | 30 | 15 |
15 | 5 | 2 | 90 | 50 | 25 | 25 | 0 | 1 | 50 | 35 |
15 | 5 | 1 | 90 | 40 | 20 | 0 | 0 | 2 | 0 | 15 |
<tbody>
</tbody>
Basically, these are poker tournament results. In this specific type of tournament, you randomly pick between 3 different prizes when you win.
I want to generate a formula that gives me the % time I have picked the "top" "middle" and "lowest" prize (to see any variance from the expected 1/3 on each). I want this individually for each of the different buy-in amounts, as well as as a whole.
So I need a formula that does the following:
% Top Prize Picked (for $15 buy-in):
When 'Column A' = 15 and 'Column I' = 1, count the amount of times Column D matches Column J (divided by when Column A = 15 and Column I = 1)
Thanks in advance