Results 1 to 3 of 3

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

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2011
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    8

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

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1