LinkBack URL
About LinkBacks
Hi All,
A break from the norm here in that this is not work related. I've just re-read my post and it is far from clear and there are some features on the spreadsheet I've not bothered to explain, so if you need anything clarifying, please just ask.
Every Friday night I attend a poker tournament with local expats. The tournament hosts around 10 - 20 expats every week and there is a winner each week (the winner of that tournament). In addition to having a weekly winner, the organiser has also decided to start a championship/league table to reward the most consistent players. For example, one particular player may come second every week for the entire year which would mean he wouldn't ever win a weekly prize however, he would more than likely be the best performer on an annual basis, hence the creation of a league to reward the best players at the end of the year.
The organiser sends through what is, quite frankly, a hideous spreadsheet to show the current league position of that week. Aside from not being aesthetically pleasing, it isn't optimised for automation/efficiency. I volunteered to create a league table for him (attached) however I'm running into some problems. Before I get to the problem, allow me to explain the spreadsheet.
- The 'Base' tab details the number of points awarded for finishing in a particular position. The number of points for finishing first, second etc. increases if there are a larger number of players.
- The 'Master' tab; columns B - DC are used to denote the details of the game. Row 4 details the number of the game (first game of the year etc.), row 5 details the date of the game, row 6 details the number of players in that game, and rows 8 downwards specify the position that each player finished in that game (note for games with less than ten people, we only note first second and third. For games with more than 15 people, we note the top 6 finishers only).
Also on the 'Master' tab we have columns DE - HD which award points to players, based on their weekly finishing position assigned to them in columns B- DC. Points are awarded using an index match to the point table on the 'Base' tab.
Columns HE - HH denote the number of total points, total wins, total second places and total third places of each player, respectively.
Columns HJ - HN then attempts to rank each player in the following order; primarily by total points. Where two or more players have the same total points, they are then ranked by number of total wins. If two or more players have the same number of total points and total wins, they they are ranked by total number of second places. If two or mre players have the same number of total points, total wins and total second places, they are then ranked by total number of third place finishes. Column HO then awards players total points based on all of the aforementioned
- The 'League-Table' tab ranks players based on their total number of points in column HO of the 'Master' tab.
My problem:
You can see duplicated names in the 'League Table'. For example, 'Maryse' is both sixth and seventh. This is because she has the same points as Marc (see cells HO14 and HO24 of the 'Master' tab) but the Index Match formula in column E of the 'League Table' cannot distinguish between duplicates. I don't know if it's possible to make it do so.
Anyway, this led me to realise that there is an eventuality where people can have the same number of points, wins, seconds and thirds. As finishing positions per tournament are only noted from a certain point (for example, for games with less than 10 people, we only note first, second and third positions and anyone finishing fourth is not recognised) it is possible for some people to have matching qualities. Hence, I need a way to distinguish between such players for the purpose of listing in the League Table.
Can anyone assist?
Register To Reply
to say "Thank you".
Bookmarks