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
|