Put the randomize function in the 'sort by' column.
=RAND()
Every time the sheet recalculates, the value will change.  You can control
this behavior with the following formula

=IF($C$1=1,RAND(),C1+1)

in cell C2 of the sort column C.  Copy C2 and paste it into the range C3:Cx
where x is your last row.  Put a 0 in c1 and C2,c3,c4.... etc will be
1,2,3,4,5..... put a 1 in c1 and the contents of C2,c3,c4.... will be random
numbers between 0 and 1.  If this is what you want but it doesn't seem to
work, write back and I can explain it more fully.
Tom Turak


-----Original Message-----
From: Mick Fitzpatrick [mailto:[log in to unmask]]
Sent: Thursday, January 24, 2002 7:50 AM

I use Excel 97. I can sort the rows in various 'logical' sequences. However,
for this project I'm working on I'd like to be able to scamble the rows so
each time they are sorted in a different sequence.

Is this possible?

              The NOSPIN Group is now offering Free PC Tech
                     support at our newest website:
                          http://freepctech.com