ExcelBanter - Randomize rows in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Randomize rows in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/76876-randomize-rows-excel.html)

Jayyyyyy

Randomize rows in Excel?

How do I randomize rows in Excel?

Chip Pearson

Randomize rows in Excel?

In an empty column, enter

=RAND()

and copy down as far as you need to go. Then, sort by that
column.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jayyyyyy" wrote in message
...
How do I randomize rows in Excel?

David J. Braden

Randomize rows in Excel?

For a more dynamic approach, get the free addin PopTools.
HTH
Dave Braden

"Jayyyyyy" wrote in message
...
How do I randomize rows in Excel?

All times are GMT +1. The time now is 05:27 AM.