+ Reply to Thread
Results 1 to 9 of 9

sort based on Column B then 2nd level Column A but it does not sort Column A

  1. 05-12-2019, 05:32 AM #1
    goodluckboss
    goodluckboss is offline
    Registered User
    Join Date
    03-29-2018
    Location
    Singapore
    MS-Off Ver
    9
    Posts
    60

    sort based on Column B then 2nd level Column A but it does not sort Column A

    Could anyone assist on this?

    Not sure what happened.

    I sort based on Column B then 2nd level Column A but it does not sort Column A
    Reply With QuoteRegister To Reply
  2. 05-12-2019, 05:34 AM #2
    goodluckboss
    goodluckboss is offline
    Registered User
    Join Date
    03-29-2018
    Location
    Singapore
    MS-Off Ver
    9
    Posts
    60
    Here is the attachment
    Attached Files Attached Files
    Last edited by AliGW; 05-12-2019 at 11:03 AM.
    Reply With QuoteRegister To Reply
  3. 05-12-2019, 05:38 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    re: sort based on Column B then 2nd level Column A but it does not sort Column A

    Please replace the .zip file with an .xls or .xlsx file. If necessary, cut the workbook down to show just enough data a to illustrate the problem. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 05-12-2019, 06:24 AM #4
    goodluckboss
    goodluckboss is offline
    Registered User
    Join Date
    03-29-2018
    Location
    Singapore
    MS-Off Ver
    9
    Posts
    60

    re: sort based on Column B then 2nd level Column A but it does not sort Column A

    Here is the csv file.

    Sorry about that.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-12-2019, 06:41 AM #5
    José Augusto
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    re: sort based on Column B then 2nd level Column A but it does not sort Column A

    Hi
    Since there are no duplicate values in A, there will be no need to sort by another level.
    Reply With QuoteRegister To Reply
  6. 05-12-2019, 06:42 AM #6
    goodluckboss
    goodluckboss is offline
    Registered User
    Join Date
    03-29-2018
    Location
    Singapore
    MS-Off Ver
    9
    Posts
    60
    but why would it need duplicate values for sorting?

    Sort via column B then sort via column A shouldn't it sort by column B then column A sort by the numerical value from smallest to largest?
    Reply With QuoteRegister To Reply
  7. 05-12-2019, 07:17 AM #7
    macropod
    macropod is offline
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    re: sort based on Column B then 2nd level Column A but it does not sort Column A

    Cross-posted at: https://www.mrexcel.com/forum/excel-...-any-help.html
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]
    Reply With QuoteRegister To Reply
  8. 05-12-2019, 07:18 AM #8
    goodluckboss
    goodluckboss is offline
    Registered User
    Join Date
    03-29-2018
    Location
    Singapore
    MS-Off Ver
    9
    Posts
    60
    Wow are these 2 the same forum?
    Last edited by AliGW; 05-12-2019 at 11:04 AM.
    Reply With QuoteRegister To Reply
  9. 05-12-2019, 07:35 AM #9
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,890

    Re: sort based on Column B then 2nd level Column A but it does not sort Column A

    Wow are these 2 the same forum?
    NO!

    Please read this link to understand: https://www.excelguru.ca/content.php?184
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort column based on multiple values in another column
    By Ozon in forum Excel General
    Replies: 14
    Last Post: 12-27-2018, 02:05 PM
  2. Sort a selection by last column - or sort a range from column B onwards to last empty cell
    By atombomb99 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-08-2018, 10:34 PM
  3. How can I sort 3 columns - Sort column A then sort column B then lastly group column C dup
    By goodluckboss in forum Excel General
    Replies: 1
    Last Post: 03-29-2018, 07:58 AM
  4. [SOLVED] creating a formula to sort names from one column's results and sort them based on another
    By cnak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2017, 08:48 AM
  5. [SOLVED] I have a sort macro. How to add script to preselect rows to sort based on column value?
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2014, 02:25 AM
  6. how to sort a column based on a the other column to an other file
    By besmir in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2014, 10:18 AM
  7. [SOLVED] sort and delete based on the values in column c and column j?
    By barbibchn in forum Excel General
    Replies: 1
    Last Post: 01-14-2013, 04:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1