hi,how to make the best present interchange formula for xmas
 

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

hi,how to make the best present interchange formula for xmas
 

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