"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
---