Try this:

Assume that the 40 names are in col A starting in row two.
Also assume that the 10 name that you want are in col C starting in row
two.
In column B, starting in row 2 put the =Rand() and copy it for forty rows
In Col C row 2 put =A2 and copy for 10 rows

Now sort the columns A and B as a block but sort on Column B.

This will give you the names sorted in random order and the first 10 names
will be in column C (In fact you could use any sequence of 10 from the
list of 40).

If you want to re-sample simply sort the data again. You will get a new
sample

Here is the way the output looks (I used names of a1, a2, a3, etc to
start with).

Name Random The Ten
a17 0.1163683 a17
a26 0.462322897 a26
a20 0.547955588 a20
a01 0.684784865 a01
a23 0.38311757 a23
a27 0.516609698 a27
a09 0.002107826 a09
a05 0.147075769 a05
a15 0.175027385 a15
a30 0.990084821 a30
a31 0.290463193
a08 0.522376428
a22 0.978672396
a21 0.361389591
a12 0.221038725
a38 0.743687859
etc etc






Boris wrote:
: I'm trying to set up a timetable (4 columns x 10 rows) that draws names at
: random from a list of 40 given names in a separate column. Any ideas how to
: get it to non-repeat the fill in?