Another play to try ..

Assuming the names are placed in A1:A40

Put in B1: =RAND()
Copy down to B40

Put in C1:
=INDEX(A:A,MATCH(SMALL(B:B,ROWS($A$1:A1)),B:B,0))
Copy down to C40

This will return a random, non repeating shuffle
of the list of names in A1:A40

(Tapping F9 will recalc and re-generate afresh)

Now you could just hide away cols A and B,
use col C as the first col in the timetable and
build the rest of the timetable in the adjacent cols

If and when required, just freeze
the timetable results elsewhere
with a copy paste special values OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Boris" wrote in message
...
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?