Hi,

If you have 16 names and more than 32 time slots, some names WILL have to be
used more than twice. Let us imagine that you have 32 time slots and 16
names.

Place the time-slot-list in A1:A32 and the name-list in B1:B16.
Copy B1:B16 and paste onto B17:B32.
Create a helper column C1:C32 with random numbers. For this, in C1
enter
=RAND() and fill-down the formula to C32.
Copy the range C1:C32, "Edit"--"Paste Special"/"Values" onto C1:C12
itself.
Now select B1:C32 (i.e., the name and random number columns; do not
select column A) and sort by column C.

Regards,
B. R. Ramachandran


"jdog" wrote:

I am trying to figure out how to take a list of names and fill a time slot
list randomly with those names. each name can only be used up to 2 times.
its around 14-16 names with 25 -35 slots.

Any suggestions