Results 1 to 3 of 3

Rearranging random numbers in a column into ordered numbers in another row

Threaded View

  1. 02-09-2016, 04:25 AM #1
    joel.mugabe
    joel.mugabe is offline
    Registered User
    Join Date
    02-05-2016
    Location
    Kigali
    MS-Off Ver
    excel 2007
    Posts
    21

    Rearranging random numbers in a column into ordered numbers in another row

    Hi guys,

    I have random numbers that I'm recording in Column A. What formula can I use in Row 9 in order to rearrange the same numbers found in Column A but in an orderly way (from smallest to largest)?

    Here attached is the sample workbook of how I want it to look like.

    Thanks for your help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. 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. [SOLVED] How to generate non-repeating random numbers in a column wihtout VB
    By luv2glyd in forum Excel General
    Replies: 4
    Last Post: 02-16-2015, 12:43 AM
  3. [SOLVED] Random Numbers in one column but cannot be repeated
    By dubcap01 in forum Excel General
    Replies: 4
    Last Post: 11-01-2014, 05:12 AM
  4. [SOLVED] Macro to pull 6 random numbers from a list of numbers.
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2014, 07:07 AM
  5. [SOLVED] Order of 3 numbers in a non ordered range
    By dualaudio454252 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2014, 10:39 PM
  6. [SOLVED] Random numbers but 3 numbers in sequence not allowed.
    By NewGen in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-31-2012, 07:51 AM
  7. Can Excel pick random numbers from 1-300 and not repeat numbers?
    By Julian in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 02:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1