+ Reply to Thread
Results 1 to 5 of 5

sorting question

  1. #1
    Registered User
    Join Date
    03-13-2006
    Posts
    22

    sorting question

    Looks like my post from early didn't post correctly, so I'll try again.

    I have a spreadsheet that has 25 rows with 33 columns of data in each row. I want to be able to sort the rows by using data in 5 columns (not just 3 that the sort drop down box offers). Any ideas on how I can do this?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,911

    Response

    You can do this in two steps.

    Sort first on columns 4 & 5 in your hierarchy followed by a second sort for 1,2 & 3. Excel should not mix up the sort that you have already done (or at least that's what the help pages said)
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Toppers
    Guest

    RE: sorting question

    Try:

    If you're sorting five columns A,B,C,D,E

    sort the last three first, C,D,E and then sort A,B.

    HTH

    "LewR" wrote:

    >
    > Looks like my post from early didn't post correctly, so I'll try again.
    >
    > I have a spreadsheet that has 25 rows with 33 columns of data in each
    > row. I want to be able to sort the rows by using data in 5 columns
    > (not just 3 that the sort drop down box offers). Any ideas on how I
    > can do this?
    >
    >
    > --
    > LewR
    > ------------------------------------------------------------------------
    > LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420
    > View this thread: http://www.excelforum.com/showthread...hreadid=538189
    >
    >


  4. #4
    bigwheel
    Guest

    RE: sorting question

    If all your data is numeric, you could use a helper column in which you
    create a formula based on the items to be sorted i.e.
    =A1*100000+B1*10000+C1*1000+D1*100+E1 then sort on that column
    (adjust the multipliers to work with your data)


    "LewR" wrote:

    >
    > Looks like my post from early didn't post correctly, so I'll try again.
    >
    > I have a spreadsheet that has 25 rows with 33 columns of data in each
    > row. I want to be able to sort the rows by using data in 5 columns
    > (not just 3 that the sort drop down box offers). Any ideas on how I
    > can do this?
    >
    >
    > --
    > LewR
    > ------------------------------------------------------------------------
    > LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420
    > View this thread: http://www.excelforum.com/showthread...hreadid=538189
    >
    >


  5. #5
    Registered User
    Join Date
    03-13-2006
    Posts
    22
    Thanks to all. Since some of the data to be sorted in alpha-numeric the sorting twice is the way I have to go.

+ 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