+ Reply to Thread
Results 1 to 3 of 3

Sorting Problem in Pivot Table Column that contains both Number and Alphabets

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    16

    Sorting Problem in Pivot Table Column that contains both Number and Alphabets

    Greetings !!

    Sorting Problem in Pivot Table Column that contains both Number and Alphabets

    https://i.imgur.com/whkpnqh.png

    In this file the survey number field contains both number and alphabets. When insert pivot table the ascending order of that column is not really ascending .. Please Help..

    https://i.imgur.com/whkpnqh.png

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    05-14-2009
    Location
    RDC
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    6,915

    Re: Sorting Problem in Pivot Table Column that contains both Number and Alphabets

    Excel sorts based on the first character of the string.
    Which are your criteria for sorting ? The shortest string before the hyphen first ?

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    16

    Re: Sorting Problem in Pivot Table Column that contains both Number and Alphabets

    Sir,
    The sorting criteria is like in J column

    https://i.imgur.com/7BhT35U.jpg

    like

    1-1
    1-1A
    1-1B
    1-2A

    like

    but as you see in pivot table column

    53--
    54-4
    54-54
    .
    .
    .


    are in lower... it should come in first

    Thanks in Advance

+ 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