ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   rearrange cells in random order (https://www.excelbanter.com/excel-discussion-misc-queries/228150-rearrange-cells-random-order.html)

Amy B

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.

Dave Peterson

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


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com