create pairs of addresses?

[philnad]

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

 

[Gazeta]

U¿ytkownik "philnad" <[email protected]>
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

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