Forum Discussion
Nested Ranking
So for the sake of clarity, please spell out the relationship between the "points" along the top and the word "score" in the tie-breaker.
The SCORE is the actual score of the football game.
What is the source of the Points numbers?
The POINTS are what the players guessed the score would be.
And where do the numbers of Wins and "Difference" come from?
The number of wins is how many games they guessed the winner of the game, and the DIFFERENCE is the difference from the actual points scored and the guessed points for the last game played.
You still haven't posted this year's spreadsheet, the one where you have a question. Nor (for this novice at pools) is it clear what the connection is between that original (which looked oh, so simple) and the one you did post (which looked oh, so extensively complicated). I didn't see, for example, a page in the one you linked to that even looked like the original.
- The original was a screen shot of the (copied) area needed for the wanted calculation. The attached link was to the entire file. The area to look at is L35:V39 on any of the numbered sheets.
OK, I've looked at these spreadsheets, and still (sorry) have a hard time making sense of them. As I've said, I don't participate in (nor have I any interest in) sports pools. It looks to me, from what I see in the source sheet--tab 18 of the workbook you shared--of the image below, as if you HAVE figured out how to sort the winners.
But if that is not the case, and if you are still seeking help, you really need to spell out the rules (as I said at the very start), the heuristics that are to be followed in doing the sort you want. I'm not asking for you to explain in Excel terms, just in plain old English.
That aside, I do have a spreadsheet in which I've been tracking the scores of a group of friends in solving the various word games that have become so popular, and I use conditional formatting to highlight the winning scores, cumulatively and for any given day. There are quite a few choices of color scales within the Conditional Formatting dialog boxes, and the fact that you have nine players would tend toward greater differentiation than shown in this example. You might want to investigate that as a simple way to leave the names in alphabetical order, but highlight the best score in the darkest green, the worst in red, with the colors arrayed between those extremes.
- Got it. That wasn’t immediately apparent. Now, unfortunately, I’m away from home, away from my computer, so won’t be able to work with it until Monday.