How to randomize Excel rows

user_1296746 0
Viewed 180912

How can I randomize lots of rows in Excel? 

For example I have an excel sheet with data in 3 rows. 
1 A dataA
2 B dataB
3 C dataC

I want to randomize the row order. For example
2 B dataB
1 A dataA
3 C dataC

I could make a new column and fill it with random numbers using =RAND() and sort based on that column.

But is this the best way to do it? The RAND equation will provide up to a million random numbers and I have a quarter of a million rows so it seems like it would work.

Thanks

I searched for a bit and while this answer about randomizing columns is close it seems like way overkill.

random excel
5 Answers

Use Excel Online (Google Sheets).. And install Power Tools for Google Sheets.. Then in Google Sheets go to Addons tab and start Power Tools. Then choose Randomize from Power Tools menu. Select Shuffle. Then select choices of your test in excel sheet. Then select Cells in each row and click Shuffle from Power Tools menu. This will shuffle each row's selected cells independently from one another.

user_86720150

For example this is our data set.

enter image description here

Then type this formular and add it B1 tO B9 cell.

enter image description here

enter image description here

Now you can go to Data tab, and select Sort smallest to largest or Sort largest to smallest as you need.

enter image description here

***Then there is a popped dialog, and check Expand the selection option. And click Sort.

enter image description here

Data range has been shuffled by rows randomly.Then you can remove the formula cells.(B column)

user_192737240
Related