Excel 2007 : Sorting two columns of data. (One with names, the other with numbers.)

**andrewmcdonald21** · 06-15-2011, 06:46 PM

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.

**andrewmcdonald21** · 06-15-2011, 07:17 PM

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.

**JBeaucaire** · 06-15-2011, 07:21 PM

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.