+ Reply to Thread
Results 1 to 2 of 2

Linking Cells so sorts of one columb sorts another

  1. #1
    Registered User
    Join Date
    04-12-2008
    Posts
    1

    Question Linking Cells so sorts of one columb sorts another

    I have two columns, one has names of baseball players, and another has a numerical rank. I would like to sort the ranks in ascending, descending order, etc. However, when I sort the ranks, it only orders the ranks, but the names of the baseball players stays the same. Is there a way for me to sort column b, and based on the sort of the values, the corresponding cell in column a will be sorted as well.

    IE I have:

    Column A Column B (only the numbers)
    Yadier Molina 2
    Mark Mulder 6
    Albert Pujols 1
    Chris Carpenter 3
    Billy Jones 5
    Tyler Johnson 4

    I sort Column B and I get:

    Column A Column B (only the numbers)


    Albert Pujols 1
    Yadier Molina 2
    Chris Carpenter 3
    Tyler Johnson 4
    Billy Jones 5
    Mark Mulder 6


    Thanks!

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    You just highlight both columns of data and sort by the second one.

+ Reply to Thread

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