W
wefva00
help!!!
How do I shuffle ROWs on microsoft excel
How do I shuffle ROWs on microsoft excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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.
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
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
W
wefva00
Just the job!
Many thanks.
Many thanks.