Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sort, >3 criteria? (97, 2000)

    I have a big list which I need (well, want!) to sort by 4 criteria. We'll call them date, credit slip, member number, type (the last one in descending order.)
    The 'sort' tool in the Data menu only invites up to three criteria.
    Any way of doing what I want in one trip?
    The supplementary - any way of storing a 'sort' specification for future use?
    Have searched this forum but not found anything.
    TIA!

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

    Re: sort, >3 criteria? (97, 2000)

    1. You can't sort on 4 columns in one go, it takes two trips to Data/Sort. First, sort on the three least important columns, in this case (I suppose) Credit Slip, Member Number and Type (descending). Then, sort on the more important column(s), in this case only one: Date. This will leave the sort order withing one date unchanged.

    2. You can record a macro of the actions you perform to sort the list. When you run the macro later on, the actions will be replayed.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort, >3 criteria? (97, 2000)

    Yippee!
    Thanks, Hans, that was well worth a five-minute wait!
    Didn't figure the 2nd trip would leave the results of the first one still in place.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: sort, >3 criteria? (97, 2000)

    Another way is to make "intermdiate columns" which COMBINE other columns.
    1)Date
    2)Credit slip & Member number
    3) type

    With several columns of NUMBERS you can add them with multiplying factors:
    For example if you have a list of numbers
    A)date
    B 10-50
    C) 1-8
    D)100-700
    E) text
    You can make a column F = a*10 + B +c/1000
    Then sort on
    Col a) col F, Col E to sort on ALL 5 columns

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort, >3 criteria? (97, 2000)

    Clever, Steve, thanks.

Posting Permissions

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