Formula for random shuffle between a range (example) b4,b78
 

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

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.

in one column enter groups of team designation so that each team designation
is listed the same number of times as there will be players.

Either next to this column or next to the column of palyers names enter in
the top cell
=rand()
copy this down to have one per player.
Select the set of random numbers and either the team designations or the
players names and sort by the column of random numbers. The playyers will now
be randomly associated with a team.

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

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.

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.