How do I randomly shuffle the cells in a column?
 

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.

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jason D" <Jason wrote in message
...
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.

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

"Jason D" <Jason wrote in message
...
| 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.