+ Reply to Thread
Results 1 to 3 of 3

Rearranging a sorted list of numbers

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    USA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    2

    Rearranging a sorted list of numbers

    Hello,

    I have columns with a quantity of 50 integers that have been sorted smallest to largest. I would like to rearrange these numbers into lists that grow in ascending order until all the numbers are exhausted.

    For example my current columns are arranged like this (1,1,1,1,2,2,2,2,3,3,4,5,5...) and I would like them to be like this (1,2,3,4,5,1,2,3,5,1,2,5,1,2...)

    The integers all fall between 1-15 if that helps. Any help would be appreciated, thank you!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,962

    Re: Rearranging a sorted list of numbers

    Let's say that your column of integers is in A, starting in row 2 (with a header in row 1).

    Insert a new blank column B (if it is not already blank), then in B2 enter

    =COUNTIF($A$2:A2,A2)

    and copy down. Then select A and B, and sort based on B first, then A second. Then you can delete column B.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    11-11-2015
    Location
    USA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    2

    Re: Rearranging a sorted list of numbers

    This worked well, thank you Bernie!

+ 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] Extract a non-sorted list with blank cells into a sorted list
    By RJK in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2015, 12:41 AM
  2. [SOLVED] Rearranging data from combined list to separate lists
    By VBADoofus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2014, 01:32 PM
  3. Rearranging words in a cell based on a list of priorities
    By zastoic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2013, 06:45 PM
  4. Replies: 5
    Last Post: 03-01-2012, 01:56 PM
  5. How do you rank sorted numbers?
    By Excelatexcel in forum Excel General
    Replies: 4
    Last Post: 09-22-2011, 12:17 AM
  6. Alphabetize list and link to other list sorted differently
    By jcclow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2010, 10:35 AM
  7. List sorting and rearranging
    By NightJumper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2010, 07:41 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