One was to do it would create a column (call it sort) in that column I would
use the Function =RAND() This will generate a random number between 0 and 1.
Then you sort the file by the Sort Column and that should randomize it. Note
that every time you hit F9 to recalculate the Random number will be
regenerated. So you can re-sort the file and get a new random order.

"K8" wrote:

I need to set up a random order list for 3 studies I'm running. We'll call
them A, B and C. I need each of my subjects to run A,B,C but in a random
order. Is there a way to randomize within rows in Excel...that seems to be
the only way I can think of to creat this list(i have about 100 subjects).

Any suggestions would be greatly appreciated.