+ Reply to Thread
Results 1 to 8 of 8

Sort random numbers in single row

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    93

    Smile Sort random numbers in single row

    Hi

    I have, usually 10 to 15 random numbers (1 to 50) but they are scattered within a few rows and columns, lets say: A1 to to D50. None of the numbers are duplicate.
    I want to sort all these numbers out in order from the lowest number found. I also want them shown on 1 row only, say E1 to E50. Can anyone help me please?

    Many thanks

    Alan

  2. #2
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: Sort random numbers in single row

    Good time of day, Alan.

    Please, attach Excel file to show us how exactly your random numbers are located.
    Best wishes and have a nice day!

  3. #3
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: Sort random numbers in single row

    Or, may be, I'll just make a guess about that =)

    For sorting numbers I used a formula like this down below. You will see an example in the attached file.

    What do you think?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Rioran; 09-30-2014 at 01:39 AM. Reason: Grammar

  4. #4
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Sort random numbers in single row

    Hi,

    a possible approach. E1 empty

    in E2 to be copied and confirmed with control+shift+enter, before to drag it down

    =IFERROR(SMALL(IF($A$1:$D$50>E1,$A$1:$D$50),1),"")


    Hope it helps
    Attached Files Attached Files
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  5. #5
    Registered User
    Join Date
    12-14-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Sort random numbers in single row

    Hi

    Here is my attachment

    Thanks for quick reply

    Alan
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    12-14-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Sort random numbers in single row

    Sorry guys, initially, I gave incorrect cell reference. The data are in A1 to AY8. Am so sorry, am just a novice in this!

  7. #7
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Sort random numbers in single row

    Hi,

    please see the file attached

    yellows formulas are array formula (please Google: Excel array formula): same numbers are sorted once

    green formulas are standard formula : sort with repetitions


    A9 has to be blank to make array formulas work.

    Hope it helps
    Attached Files Attached Files
    Last edited by canapone; 09-30-2014 at 02:16 AM.

  8. #8
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Sort random numbers in single row

    This should gather it for you
    Put in B9: =IF(COUNT(B1:B8)=0,"",INDEX(B1:B8,MATCH(TRUE,INDEX(B1:B8<>"",),0)))
    Copy across as far as required
    -----------------------------------------------------------------------------------------
    Success? Wave it, click on the little star at the bottom left of my response

+ 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. Filtering random numbers without regenerating random numbers
    By ptack in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2022, 04:03 PM
  2. Generate random numbers between 1 - 100 in a single cell
    By inepab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 05:08 AM
  3. [SOLVED] Non-random numbers generated by excel's data analysis random gener
    By Allie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-17-2005, 02:05 AM
  4. [SOLVED] Re: Non-random numbers generated by excel's data analysis random gener
    By Harlan Grove in forum Excel General
    Replies: 2
    Last Post: 09-13-2005, 12:05 PM
  5. How to sort random numbers in columns
    By webehere in forum Excel General
    Replies: 4
    Last Post: 01-24-2005, 02:07 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