create pairs of addresses?

P

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
 
G

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
Click to expand...

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
 
Top