Use brute force, use a help column and put =RAND() and copy down the same
number of rows, then just sort by the help column

Regards,

Peo Sjoblom

"M Spangler" wrote:

Reo,

This gives me a random selection from the range for one cell. How do I
shuffle the entire range?
"Peo Sjoblom" wrote:

Assume the range is A1:A20

=INDEX(A1:A20,INT(RAND()*(21-1)+1))

everytime you press F9 it will return a value from A1:A20



Regards,

Peo Sjoblom

"m spangler" wrote:

Does any one have a formula for a random shuffle between a range? This is
needed to draw random teams for a golf tournament.