• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

How do I mix up rows in Excel

I have an excel spredsheet that has 60000 rows.

How do I mix up all of the rows so that are not in the sequence that they are not currently in and completly mixed up.
0
Ed
Asked:
Ed
1 Solution
 
barry houdiniCommented:
One way would be to put this formula in a blank column in the first row

=RAND()

 copy down to the end of the data then sort all the data, using the new column as the sort criteria (ascending or descending - doesn't  matter)

That will give you a random sort

regards, barry
0
 
PlantwizCommented:
..or you could sort by different columns as well.

otherwise as barryhoudini noted, the =RAND() should accomplish what you want.
0
 
EdAuthor Commented:
Perfect, Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now