Shuffling Rows

  • Thread starter Thread starter wefva00
  • Start date Start date
Could you be a bit more specific about what exactly you want to
do?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I have rows off data which I could sort in ascending/descending
order..but What I'd like to do is shuffle the rows in a random order.
 
In an empty column next to your data, enter "=Rand()", without the quotes,
in the first row of your data. Copy this formula down as far as your data
goes. This produces a column of random numbers. Now sort all your data
together with this new column, and sort on that new column. Delete the new
column. Done
HTH Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
shuffle specific ppt slides when open with vba? 0
Sticky-pod anyone...? 0
How to Shuffle the data at ROW level. 2
Shuffle slides 1
Random shuffle cell values? 1
Shuffling my slides 2
Generate list of unique random integer values? 5

Back
Top