+ Reply to Thread
Results 1 to 6 of 6

Custom sort order problem

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    3

    Custom sort order problem

    I am using Excel 2010. I have created a custom list and would like to sort on it. I select it in the sort box, but it does not sort on this list. It sorts it alphabetically. Can anyone help me with this problem?
    Thanks.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,626

    Re: Custom sort order problem

    Maybe a small example sheet would help?

  3. #3
    Registered User
    Join Date
    10-04-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Custom sort order problem

    Here's a sample file. I made a small table of the data I'm working with. This time the sort order was not alphabetical. But this sample was only a one level sort. For all my data I performed a 3 level sort, using the custom list as the 2nd level. Thanks for trying to help.
    Attached Files Attached Files

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Custom sort order problem

    i sorted it on city and on country, both times it sorted perfectly. you shouldnt need to, but did yoou highlight the table 1st and then sort?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    10-04-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Custom sort order problem

    I guess I should give you all the information.
    I want to sort on EPA class in this order: Major, SM opt out, SM R208a, minor
    I created a custom list, but it would not sort in that order.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Custom sort order problem

    if your custom list is "NEW LIST", it does not contain any data (at least, in the file you posted)

+ 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