Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Macro Help: Concatenate Populated Cells in Column A | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |