I am trying to create a random match/pair of a person on one team (Team Member) to a person on a different team (Doesn't have the same Team Lead). They cannot meet with themselves and they cannot repeat.
In this example: Mary and Jane will never meet because they have the same Team Lead Mark. If they are on both list, team member and team lead they will never meet IE: Mary will never meet with herself. If they meet once they will not meet again in future interactions.
I can understand the =rand() would work if I didn’t have to worry about that second variable of a team lead.
Thanks in advance for the assistance!
Team Member | Team Lead |
Sam | Mary |
Mary | Mark |
Jane | Mark |
John | Sam |
Sue | John |
David | Fran |
In this example: Mary and Jane will never meet because they have the same Team Lead Mark. If they are on both list, team member and team lead they will never meet IE: Mary will never meet with herself. If they meet once they will not meet again in future interactions.
I can understand the =rand() would work if I didn’t have to worry about that second variable of a team lead.
Thanks in advance for the assistance!