help with random lists

[Enrique Arredondo]

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

 

[RagDyer]

Biff, one of the "regulars" around here, put a lot of time into answering a
similar post.

See if it can do what you want:

http://tinyurl.com/29fgay

 

[Enrique Arredondo]

AWESOME

thanks so much

Biff, one of the "regulars" around here, put a lot of time into answering
a similar post.

See if it can do what you want:

http://tinyurl.com/29fgay

 

[RagDyer]

Biff deserves the gratitude ... he did all the work!

That's the advantage of the archives ... many can benefit.