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