I have a list of team memebers in a single division we are wanting to randomly pair each month for meetings. In the file you see we have the name of the team memeber and the Supervisor Name, in yellow highlight. In the read writing would be the expected results. We need to randomly generate a name to populate each month. The final would have 12months.
Criteria: They can not meet more than once, they can not meet with themselves (as some are both Team member and Supervisor) and they can not meet if they have the same Supervisor.
Criteria: They can not meet more than once, they can not meet with themselves (as some are both Team member and Supervisor) and they can not meet if they have the same Supervisor.