| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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. |
| 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) | |||
Threaded Mode
