| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rearrange cells in random order
I have a list of words in a column that I would like to rearrange in a random
order. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rearrange cells in random order
Insert an adjacent column.
Put =rand() in the top cell of that column Drag it down as far as you need. Select the entire range and sort by this "helper" column. Amy B wrote: I have a list of words in a column that I would like to rearrange in a random order. Any help would be appreciated. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tough problem adding cells from different sheets, in random order | Excel Worksheet Functions | |||
| is it possible for excel to take several cells in random order and | Excel Discussion (Misc queries) | |||
| How can I sort a selection of cells into random order? | Excel Discussion (Misc queries) | |||
| Rearrange numbers from a column in a different order in a second c | Excel Discussion (Misc queries) | |||
| can i rearrange names in alphabetic order... | Excel Discussion (Misc queries) | |||
Hybrid Mode
