how to automatically jumble a list of numbers

J

JULIE

i HAVE A LIST OF NUMBERS THAT I NEED TO SCRAMBLE. HOW CAN I DO THAT
AUTOMATICALLY IN EXCEL?
 
E

Elkar

Insert a new column next to your data.
In this new column, enter the formula:

=RAND()

Copy down as needed.
Now, sort all of your data by this new column.
To re-scramble, just sort the data again.

HTH,
Elkar
 
M

Max

Julie said:
i have a list of numbers that i need to scramble.
how can i do that automatically in excel?
Click to expand...

One way ..

Assume items* to be scrambled are listed in say, A1:A10
*can be numbers, text, whatever

Put in B1: =INDEX(A:A,RANK(C1,$C$1:$C$10))
Put in C1: =RAND()
Select B1:C1, copy down to C10

B1:B10 will return a random scramble of what's in A1:A10
Just press F9 to recalc & generate a fresh scramble
(Copy n paste special as values elsewhere if required)
 
Top