|
Selecting a random subset without repeating -- using the Rank
function The advantage of
this method is that the process of regenerating a new list is as
easy as recalculating the worksheet (on a Windows machine, pressing
the F9 key). The disadvantage is that as soon as a
recalculation is done, the old result is lost forever -- unless, of
course, it was saved somewhere else.
| Suppose the group from
which the selection has to be made is in A1:A11.
Then, in the adjacent column, enter the
formula =RAND(). In the next column over, enter the
formula =INDEX($A$2:$A$11,RANK(B2,$B$2:$B$11)).
Copy C2 down to cover as many cells as desired selections. |
 |
|
|
