Brian Thomas
New member
- Joined
- Nov 27, 2012
- Messages
- 30
- Reaction score
- 0
- Points
- 0
Hi. After wrestling with my spreadsheet for a few hours I have had to admit defeat and seek help here!
I run a poker league and keep the table updated via the attached spreadsheet which someone helped me make. I'm no longer in touch with them and can't edit it myself and would be really grateful if someone could help me with the following formula.
I would like the cell U6 to calculate the following:
Count the total number of players on Monday 5/11/12 then work out from the points I have entered at I6-I29 who came 1st, 2nd, 3rd and 4th. It does this at the moment but I need it to copy the relevant payout information from the red, green, blue and peach rows below the main table. This is because sometimes the nights "pot" is divided between the top two finishers and at the moment that means the "Earnings" cell is sometimes incorrect as it calls information from the lookup table at the foot of the page. What I'd like to be able to do is just manually enter the split amount in the colored cells in the table so that the published table shows the correct prizes as well as the correct earnings (which means the cell U6 and all the others need to draw their info from the colored cells)
I hope this makes some sense. Any questions please ask.
Many, many thanks in advance,
Brian.
I run a poker league and keep the table updated via the attached spreadsheet which someone helped me make. I'm no longer in touch with them and can't edit it myself and would be really grateful if someone could help me with the following formula.
I would like the cell U6 to calculate the following:
Count the total number of players on Monday 5/11/12 then work out from the points I have entered at I6-I29 who came 1st, 2nd, 3rd and 4th. It does this at the moment but I need it to copy the relevant payout information from the red, green, blue and peach rows below the main table. This is because sometimes the nights "pot" is divided between the top two finishers and at the moment that means the "Earnings" cell is sometimes incorrect as it calls information from the lookup table at the foot of the page. What I'd like to be able to do is just manually enter the split amount in the colored cells in the table so that the published table shows the correct prizes as well as the correct earnings (which means the cell U6 and all the others need to draw their info from the colored cells)
I hope this makes some sense. Any questions please ask.
Many, many thanks in advance,
Brian.