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

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


"JULIE" wrote:

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

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

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---