This is a sorting problem. I think need two formulas. Here’s the problem:
160 participants and 20 mentors will be involved in two training sessions – A and B.
The formula for Session A would randomly assign the participants to the mentors, with each mentor getting 8 participants. The formula for Session B would reassign the participants so that each mentor gets 8 new participants and no two participants from a former group would be assigned to the same new mentor.
I was thinking of identifying the participants as P1 through P160 and the mentors as M1 through M20. Can the sorting be done using two spreadsheets – one for the participants and one for the mentors - or must I use just one spreadsheet?
