Shuffling Rows

C

Chip Pearson

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
 
W

wefva00

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.
 
O

Otto Moehrbach

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
 

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

Shuffling my slides 2
Shuffle slides 1
How to collate so the pages are not reversed? 1
VB6 Programming Question 1
How to Shuffle the data at ROW level. 2
random permutation of an array 5
Can I shuffle slides automatically? 3
Random Names and Command Button 1

Top