How do I shuffle a group of cells randomly in Excel?
 

generally this is achieved via the use of a "helper"column - another column
adjacent to what you want to sort where you type in a function to generate
random numbers (e.g. =ROUND(RAND()*100,0) ) and then you change this column
from a formula to values (copy it, select it again - edit / paste special -
values) and then you sort of this column to get a "random" sort. The column
can be deleted once you've sorted.

Cheers
JulieD

"golfmoab" wrote in message
...