How do I randomly shuffle the cells in a column?

[Guest]

In Excel 2003, I have a column, say a1-a10, with certain entries. I need to
create another column, b1-b10, with the same entries assigned randomly
(shuffled) to the cells.

 

[Max]

Just one way ..

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 returns a random shuffle of what's in A1:A10

Press F9 to re-shuffle

 

[ScottO]

One way would be to make your copy entries in b1 - b10, then in c1 -
c10 enter the formula =RAND().
Then do a sort on b1:c10, using ColC as the sort key.
That should do it.
Rgds,
ScottO

| In Excel 2003, I have a column, say a1-a10, with certain entries. I
need to
| create another column, b1-b10, with the same entries assigned
randomly
| (shuffled) to the cells.