Brian Thomas
New member
- Joined
- Nov 27, 2012
- Messages
- 30
- Reaction score
- 0
- Points
- 0
Hi,
If someone out there would be willing to help me get the following set up to my specification I'd be more than happy to PayPal them the cost of a nice bottle of wine or a case of beer! If you think you can help please let me know.
-----------
I run a small poker league and enter the results each week into a table that I had some help designing recently. I now want to apply a formula that I've been given to the results each week that will improve the way we determine the league champion. I have very little knowledge of Excel and would appreciate it if someone could help set up this formula and the rest of the worksheet in such a way that I just enter the results each week and everything else is done automatically. I've attached a file that features two worksheets. The first is the old one which features all the formula's, look up tables and conditional formatting. The second is just a template with all formula's etc. removed. It's basically how I'd like the table to look when finished. I've pasted the new formula that should calculate the scores below the table. The first weeks results have all been entered manually. The part of the original table that calculates earnings has been left off the new worksheet as having added new columns for both place and points, the formula gave errors which I couldn't fix so this also needs to be updated!
Many thanks,
Brian
View attachment Table_02.xlsx
If someone out there would be willing to help me get the following set up to my specification I'd be more than happy to PayPal them the cost of a nice bottle of wine or a case of beer! If you think you can help please let me know.
-----------
I run a small poker league and enter the results each week into a table that I had some help designing recently. I now want to apply a formula that I've been given to the results each week that will improve the way we determine the league champion. I have very little knowledge of Excel and would appreciate it if someone could help set up this formula and the rest of the worksheet in such a way that I just enter the results each week and everything else is done automatically. I've attached a file that features two worksheets. The first is the old one which features all the formula's, look up tables and conditional formatting. The second is just a template with all formula's etc. removed. It's basically how I'd like the table to look when finished. I've pasted the new formula that should calculate the scores below the table. The first weeks results have all been entered manually. The part of the original table that calculates earnings has been left off the new worksheet as having added new columns for both place and points, the formula gave errors which I couldn't fix so this also needs to be updated!
Many thanks,
Brian
View attachment Table_02.xlsx
Last edited: