+ Reply to Thread
Results 1 to 2 of 2

Incorrect Slicer sorting (ascending)

  1. #1
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    Incorrect Slicer sorting (ascending)

    Hi,
    My slicer shows incorrect ascending sorting. It displayed as
    0-4, 10-14, 15-19, 20-24, 5-9. What I expect the slicer to sort is 0-4, 5-9, 10-14, 15-19, 20-24 instead. or did i do something wrong here?

    Your help is greatly appreciated. Please find attachment.

    Thank-You very much
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Incorrect Slicer sorting (ascending)

    Groups are text, not numbers, so they sort in alphanumeric order - hence '2' followed by anything comes before '5' followed by anything (or nothing). I think you will need to create your own banding column that you can format with say a leading 0 or space for the single digit numbers so that they sort the way you want.
    Rory

+ 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. sorting ascending and descending order
    By beepetark in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-30-2019, 01:10 PM
  2. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  3. Sorting from ascending orders.
    By ideliveryx in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-01-2017, 03:16 AM
  4. [SOLVED] Ascending sorting within cell
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2014, 11:02 AM
  5. [SOLVED] Sorting Columns in Ascending Order
    By COLIN_303 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 07:51 AM
  6. [SOLVED] Pivot Slicers from multiple Caches - problem with 2nd Slicer displaying incorrect data
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2013, 03:06 AM
  7. ascending sorting
    By fofomama in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2006, 10:45 AM

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