How do I randomize rows in Excel?
C Chip Pearson Mar 13, 2006 #2 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
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
D David J. Braden Mar 17, 2006 #3 For a more dynamic approach, get the free addin PopTools. HTH Dave Braden
