![]() |
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. |
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