help with random lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Enrique Arredondo - 04 Dec 2007 19:28 GMT

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

Reply to this Message

RagDyer - 04 Dec 2007 20:40 GMT

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>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
[quoted text clipped - 12 lines]
> lore
> viole

Reply to this Message

Enrique Arredondo - 04 Dec 2007 21:16 GMT

AWESOME

thanks so much

> Biff, one of the "regulars" around here, put a lot of time into answering
> a similar post.
[quoted text clipped - 20 lines]
>> lore
>> viole

Reply to this Message

RagDyer - 05 Dec 2007 00:28 GMT

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

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

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> AWESOME
>
[quoted text clipped - 24 lines]
>>> lore
>>> viole

Reply to this Message