View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.