View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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