Random Sorting of Data In Rows

[TINHAMMER]

I have a Microsoft Excel Worksheet with data in 64 rows and 4 columns. I would like to sort the data in the rows randomly, keeping A1,B1,C1, and D1 together like a playing card and A2, B2, C2, and D2 together as another playing card. Thus, I end up with 64 playing cards.

How do I randomly shuffle these rows?

I have attached a Microsoft Worksheet with this data.

[Pete_UK]

You could use column E as a temporary helper column, using this formula in E1:

=RAND()

copied down to E64. Then you could sort columns A to E, using column E as the sort key.

You can delete column E afterwards.

Hope this helps.

Pete

[TINHAMMER]

Thank you that did the trick.

[Pete_UK]

Glad to help, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete