create pairs of addresses?
 

I have a list of names and addresses and I want to
automatically/randomly "pair up" 2 names at a time from the entire
list.
For example: Person A on the list is automatically paired up with, say,
Person T on the list.
It's for a penpal-like online community.

Is there a function for this? Or another way?

Thanks


--
philnad
------------------------------------------------------------------------
philnad's Profile: http://www.excelforum.com/member.php...o&userid=32954
View this thread: http://www.excelforum.com/showthread...hreadid=527786

create pairs of addresses?
 

U¿ytkownik "philnad"
napisa³ w wiadomoœci
...

I have a list of names and addresses and I want to
automatically/randomly "pair up" 2 names at a time from the entire
list.
For example: Person A on the list is automatically paired up with, say,
Person T on the list.
It's for a penpal-like online community.

Is there a function for this? Or another way?

Thanks


--
philnad
------------------------------------------------------------------------
philnad's Profile:
http://www.excelforum.com/member.php...o&userid=32954
View this thread: http://www.excelforum.com/showthread...hreadid=527786


i would divide your list into 2 parts
then 1st part i would randomly sort ( using rand formula placed in a blank
column next to your data )
then copy/ paste 2 parts
mcg