How do I randomize words within a row?

[Guest]

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.

 

[Guest]

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.

 

[Guest]

one method would be to originally set up the columns as
ABC
ACB
BAC
BCA
CAB
CBA
and copy this down to the bottom of the list
then in the top of an adjacent column enter = rand() and copy down to the
end of the data
select the four columns and use <Data><sort> by the column with the rand()
in it.
delete the RAND() column.

The advantage of this method compared to some of the other random methods is
that there is no more than one as the difference in the number of repeats of
each combination order.