Random Pairing with multiple criteria

Occasional Visitor

I need to randomly pair a team. Criteria: They can not meet more than once ever, they can not meet anyone on their same team and there will be new people added, deleted and teams change, as time goes on. 

 

Data:

Team Mbr                Team

John                           A

Pam                            A

Jane                            B

Mary                           C

Mark                           D

0 Replies