Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Randomly Sort a Series of Numbers
I have a column of numbers (for ex.: 1-100) which I desire to sort randomly.
How would I go about doing this? I am appreicative of any assistance. |
#2
|
|||
|
|||
One option:
If your data is in A1:A100, put =rand() in B1 and copy down. Sort by Column B. tj "Shoelaces" wrote: I have a column of numbers (for ex.: 1-100) which I desire to sort randomly. How would I go about doing this? I am appreicative of any assistance. |
#3
|
|||
|
|||
In an adjoining column, enter this formula:
=RAND() And *double click* on the "fill handle" to automatically copy it as far down as there are numbers in the original column. Now simply select *both *columns and sort on the column containing the Rand() formula. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Shoelaces" wrote in message ... I have a column of numbers (for ex.: 1-100) which I desire to sort randomly. How would I go about doing this? I am appreicative of any assistance. |
#4
|
|||
|
|||
Thank you for your help.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |