Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Sorting - why can you only sort by 3 columns?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    California
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to sort data by more than the three columns in the sort option....Lotus 123 had more fields to choose 5 years ago.


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Excel limits to 3 sadly and your need VBA to over come this...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    No way to sort on more than three in one shot. One workaround is to sort on the least important columns first.

    1. Sort on columns D and E, for instance
    2. Then sort on columns A,B, and C which are your highest priority sorts.

    Bye,
    Jay

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-25 10:45, lars wrote:
    Is there a way to sort data by more than the three columns in the sort option....Lotus 123 had more fields to choose 5 years ago.

    If you want to sort based on 5 columns just do it in 2 passes. For example, first sort on columns C, D and E. Next, sort on columns A and B. That's the same as sorting on columns A, B, C, D and E.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    California
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That's the way i do it but I was hoping for something else.

    Thanks for the advice

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-25 11:16, lars wrote:
    That's the way i do it but I was hoping for something else.

    Thanks for the advice
    If each of your columns contained the same data type you could also concatenate the 5 values together on each row and sort on that combined column. For example...

    =A2&","&B2&","&C2&","&D2&","&E2

    [ This Message was edited by: Mark W. on 2002-04-25 11:28 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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