I'm setting up a spreadsheet for a pool for the US Open this weekend.
The problem I'm facing is with the "Leaderboard." I have two columns of data: 1. the pool participant's name (column S), and 2. the total scores of their players (column T.)
I want the leaderboard to automatically be listed from lowest score to highest score when the scores are updated/refreshed. (A real-time webpage leaderboard will be linked in the file so the scores will always be changing.)
The scores will change in "column T," but the highest score (along with the participant's name in "column S") won't go to the top of the leaderboard. Or conversely, the lowest score and name won't go to the bottom.
I've attached an example of my dilemma. The leaderboard is highlighted in yellow.
Thanks for the help.
I accidentally posted in the wrong forum.
Could a Mod move this to the Excel General forum; or explain how I can delete this thread.
Add another table off the right to gather your raw scores and rank them, with a positional tiebreaker (first in the list gets higher score in cases of ties) then use that table to display your leaderboard.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks