How do I scramble a list in excel?

C

Cate

I would like to scramble a list of words so that they are not in an
particular order. Can I do this somehow?
 
B

bj

The simplest way is to insert =rand() in the cells next to the word column
select both columns and sort by the rand column. If you dont like the order
just sort again.
 
R

Ron Coderre

Just run this formula in the cells next to the words then sort both columns:
=RAND()

Regards,
Ron
 
P

Peo Sjoblom

Assuming the words are in individual cells, use a help column
and in the first adjacent cell type

=RAND()


copy down

select both column and sort by the formula column,
then delete the formula column

Regards,

Peo Sjoblom
 
C

Cate

what is a help column?

Peo Sjoblom said:
Assuming the words are in individual cells, use a help column
and in the first adjacent cell type

=RAND()


copy down

select both column and sort by the formula column,
then delete the formula column

Regards,

Peo Sjoblom
Click to expand...
 
J

JE McGimpsey

It's an unused column that you can use to sort on. So if your words are
in A1:A20, and column B is unused, enter

B1: =RAND()

and copy down to B20. Select A1, then choose Data/Sort... and sort on
column B.
 
Top