I agree that it sounds like homework / assignment, but possible is:

Assuming that your list of names is in B1 to B16, and that column A is
free.

insert
=rand()
in a1 to a32 (ie, twice the name range 14 to 16)

then use


=INDEX(B$1:B$16,IF(MATCH(SMALL(A$1:A$32,ROW()),A$1 :A$32,0)<17,MATCH(SMALL(A$1:A$32,ROW()),A$1:A$32,0 ),MATCH(SMALL(A$1:A$32,ROW()),A$1:A$32,0)-16))

- explained as Index (select) b1:b16 depending on:
use the smallest of A1 to A32 (minus 16 if applicable) according to
the current row number (thus the 5th row selects the 5th smallest)

This does not ensure that all names are used at least once.
It also is random and does not prevent a name being selected
consecutively.

Hope this helps.


R. Choate Wrote:
Sounds like a homework problem. Are you trying to solve this with VBA or
with formulas? How far have you gotten with it?

--
RMC,CPA


"jdog" wrote in message
...
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476507