ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a simple way to do a randomizing sort? (https://www.excelbanter.com/excel-discussion-misc-queries/46271-there-simple-way-do-randomizing-sort.html)

BrentG

Is there a simple way to do a randomizing sort?
 
Is there a way to randomize several columns of data without having to add an
additional column and then generating random numbers and doing a normal sort?

bj

myour description is the simplest way. you could write a macro to do it
outside the sheet, but to randomize the data, you have to generate random
numbers somewhere

"BrentG" wrote:

Is there a way to randomize several columns of data without having to add an
additional column and then generating random numbers and doing a normal sort?



All times are GMT +1. The time now is 03:01 PM.

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