+ Reply to Thread
Results 1 to 8 of 8

Help! Sort Data in Ascending Order which contains duplicates!

  1. #1
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Help! Sort Data in Ascending Order which contains duplicates!

    Hi,

    What i am trying to do is one of the most primitive tasks that could be required of a data manipulation program, such as excel: I have a column of data. I need the data to be copied into another column adjacent to it, where the data is in ascending order. Problem is, there are duplicate values in the list. The duplicate values are non-unique, so they don't need to be in a specific order relative to one another, i just need the data in order!

    Here is a template of what I need: https://www.dropbox.com/s/143xk4qwh0...mple.xlsx?dl=0


    Any help is greatly appreciated.
    Thank you

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    If you sort the data, the duplicates will be in the correct sort order. Maybe you are just asking "How do I sort a column of data."

    Copy the raw data
    Paste in another column
    Select the new column
    Go to the Data tab
    Click on the Sort Ascending button ascendingsort.jpg

    Is this a one-time task, or do you need to repeat this many times? You could record a macro to do it.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    Hi, thanks for the reply.

    Yes I need this to be dynamic. A macro is a good idea, but my coding isn't good enough to be able to implement this automatically. I need this too loop.

  4. #4
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    Anyone? . . .

  5. #5
    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,728

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

    From the forum rules (link in the main menu above):
    • If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
    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.

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    This one maybe in G13 and then pulldown
    =SMALL($F$13:$F$62,ROWS($13:13))
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  7. #7
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    popipipo,

    That worked great! Thank you

  8. #8
    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,728

    Re: Help! Sort Data in Ascending Order which contains duplicates!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. [SOLVED] How to sort data in Ascending Order of Date
    By atanu021 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-17-2017, 03:33 AM
  2. Sort the final digits and sort in ascending order
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 11:58 AM
  3. [SOLVED] Sort Ascending order and eliminate zero data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2013, 01:28 PM
  4. Copy Data, Remove Duplicates & Sort Ascending
    By DrifterX in forum Excel General
    Replies: 0
    Last Post: 04-07-2013, 05:44 PM
  5. [SOLVED] List Ascending Order shows duplicates
    By tomlancaster in forum Excel General
    Replies: 3
    Last Post: 04-05-2012, 06:10 PM
  6. Replies: 7
    Last Post: 09-10-2010, 03:25 PM
  7. Copy Data, Remove Duplicates & Sort Ascending
    By knightcloud in forum Excel General
    Replies: 1
    Last Post: 09-09-2010, 12:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1