Hi, I'm a bit out of my realm on some of these functions I'm looking to accomplish in the attached workbook for my home poker league. I haven't been here in a while but you guys were a big help when I set up this spreadsheet before. Things have changed and I've been charged with coming up with a new spreadsheet to total our league.
The first sheet in the workbook I'm trying to set it up so when the number of players are entered and the place of the player is entered the function knows to pull the points earned from the table on the right side that tells how many points are earned by the amount of players that played in the game.
The second sheet I'm trying to take the sum of the points column with the bottom 2 points earnings removed. Right now I have it set to only count the top 21 but if there aren't 21 numbers entered it doesn't give the true weighted points with the bottom 2 cells in the series removed.
Thanks in advance - I appreciate any insight if this can be done or if there is a better way to set this up!
Home Poker League.xlsx
Bookmarks