G Guest Mar 16, 2005 #1 How can I randomly assign a range of numbers to a range of cells without the numbers repeating?
M Max Mar 17, 2005 #3 Another way to play with .. Assuming the list of numbers* to be assigned is in A1:A10 *or whatever item needs to be assigned Put in say, E1: =RAND() Copy down to E10 Put in B1: =INDEX(A:A,MATCH(SMALL(E:E,ROWS($A$1:A1)),E:E,0)) Copy B1 down to B10 B1:B10 will return a non-repeating randomized shuffle of the 10 numbers (or items) in A1:A10 Press / tap F9 to recalc / re-generate a fresh selection Just freeze the results elsewhere with a copy > paste special > values > ok Adapt to suit ..
Another way to play with .. Assuming the list of numbers* to be assigned is in A1:A10 *or whatever item needs to be assigned Put in say, E1: =RAND() Copy down to E10 Put in B1: =INDEX(A:A,MATCH(SMALL(E:E,ROWS($A$1:A1)),E:E,0)) Copy B1 down to B10 B1:B10 will return a non-repeating randomized shuffle of the 10 numbers (or items) in A1:A10 Press / tap F9 to recalc / re-generate a fresh selection Just freeze the results elsewhere with a copy > paste special > values > ok Adapt to suit ..
