Random Sort?

  • Thread starter Thread starter Nivek
  • Start date Start date
N

Nivek

I have 6 columns of 4 digit numbers. Each column has a different range and
amount of numbers (Col A has 150 - 4 digit #'s, B has 115, C has 229, etc).
I need a way to sort each column separately so that the numbers are sorted
in a random order.

I know this has to be possible in Excel but being a novice using Excel I
haven't found a way to do it.

If not possible in Excel is there possibly a stand-alone program that can
achieve this?

Thanks for any advice.
 
Hi Nivek!

Before doing this you should save. You should also make sure that you have
record numbers for each row of your data so that you can get back to the
original order. Lastly, when sorting data, make sure that you select the
entire data table and not just a single column.

Insert a new column
Enter =RAND()
Copy down the 150 rows.
Select all 150 entries in this new column
Copy
Edit > Paste Special > Values > OK
Now sort using the random numbers as your criteria.


--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top