See answer to your post in the excel group.

Please don't multi-post.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Enrique Arredondo" wrote in message
et...
A friend is organizing a secret present interchange and I need a formula
that would tell me who gives who but duplicates not allowed. I tried using
randombetween but I get dups. How can YOu do it ? Also CAn I have
exceptions like guy A never gives to guy C ?

This is the list of guys :
ame
leo
cely
tere
richard
tamez
vero
tono
lore
viole