Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Sort Criteria (XP)

    Me again - have 9 columns I need to sort by - any way to accomplish this?

    Have attached a sample.

    Thanks again

    Aunt Linda
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Sort Criteria (XP)

    Excel can sort on up to three columns at a time (both interactively and in a macro), so if you want to sort on 9 columns, you have to do it in groups of three, starting with the three least important columns and ending with the three most important ones.
    In your example, if you want to sort on A, and within that on B, etc., the steps would be as follows:
    - Select cell A1.
    - Select Data | Sort
    - Select Beech Staff in the first dropdown, Project etc. in the second dropdown and Presenting etc. in the third one.
    - Click OK.
    - Select Data | Sort
    - Select BOC in the first dropdown, Facilities Staff in the second dropdown and FUSD, Other Staff in the third one.
    - Click OK.
    - Select Data | Sort
    - Select Outside Dignitaries in the first dropdown, Media in the second dropdown and FUSD Board etc. in the third one.
    - Click OK.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Sort Criteria (XP)

    That was much too easy - I actually thought of that but wasn't smart enough to try it B4 posting . . . sigh - again.

    Have a great weekend

    Thank you

    AL

Posting Permissions

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