+ Reply to Thread
Results 1 to 5 of 5

Custom sort w. bracket wont apply correctly

  1. #1
    Registered User
    Join Date
    11-08-2018
    Location
    Copenhagen
    MS-Off Ver
    16.16.3 for Mac
    Posts
    6

    Custom sort w. bracket wont apply correctly

    Hello,

    I am trying to create a custom list to sort bracket values with.

    I have created a custom list with the following values:

    0-1,000
    1-2,000
    2-3,000
    3-4,000
    4-6,000
    6-8,000
    8-10,000
    10,000+

    However, when I apply the custom sort list to my pivot, it shows me the following order:

    0-1,000
    1-2,000
    10,000+
    2-3,000
    3-4,000
    4-6,000
    6-8,000
    8-10,000

    I.e. with the 10,000+ value out of order. The custom sort list has the values listed correctly, and they are all formatted as text before I created the list.

    Does anyone have an idea of why the custom sort function isn't working for me?

  2. #2
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    148

    Re: Custom sort w. bracket wont apply correctly

    Change your custom list to:
    0-1,000
    1-2,000
    2-3,000
    3-4,000
    4-6,000
    6-8,000
    8-10,000
    9-10,000+
    Leo Skywalker
    May the force be with you.

  3. #3
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    148

    Re: Custom sort w. bracket wont apply correctly

    1 post, hit and run...

  4. #4
    Registered User
    Join Date
    11-08-2018
    Location
    Copenhagen
    MS-Off Ver
    16.16.3 for Mac
    Posts
    6

    Re: Custom sort w. bracket wont apply correctly

    Hi LeoSkywalker,

    Sorry for the lack of response.

    The issue still persists - I create custom lists, but when I then use them to sort, the sorting does not happen according to how I entered the order.

    Point in case:
    I have created a custom sort list:
    Camper for Life (<100)
    Tent Captain (<500)
    Totem Alliance (<1,000)
    Fire Keepter (<2,000)
    Council Ring (<5,000)
    Sacehm (<10,000)


    When I then apply the sorting to a row of fields, the outcome is:
    Camper for Life (<100)
    Tent Captain (<500)
    Council Ring (<5,000)
    Fire Keepter (<2,000)
    Freddie's Circle (<20,000)
    Rising Suns (<40,000)
    Sachem (<10,000)
    Totem Alliance (<1,000)
    Trail Blazers (40,000+)

    Mads.

  5. #5
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    148

    Re: Custom sort w. bracket wont apply correctly

    Post an example file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. List wont go into a-z order correctly
    By jono121ukk in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-26-2017, 06:28 PM
  2. [SOLVED] Macro to select a data range then apply a custom sort
    By dvsbyknight in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-20-2013, 01:50 AM
  3. Excel 2007 : Custom List does not sort correctly
    By tanda in forum Excel General
    Replies: 0
    Last Post: 11-15-2011, 07:32 PM
  4. IF statement wont work correctly
    By dannyshezo in forum Excel General
    Replies: 10
    Last Post: 11-04-2011, 01:02 PM
  5. formula wont copy correctly into next row
    By imatthews2001 in forum Excel General
    Replies: 6
    Last Post: 08-25-2011, 04:34 PM
  6. Workhours code wont loop correctly.
    By prefix in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-08-2011, 10:34 AM
  7. Replies: 5
    Last Post: 08-18-2010, 07:10 PM

Tags for this Thread

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