Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) |