In Excel I must distribute 30 people randomly in 6 groups of 5 people 4 times. Is it possible to do this so no person gets in a group with someone they have been in a group with before?
The problem is kind of like the question on the follwing link, but I need to solve it in Excel: How to create 21 random groups of 10 people 4 times, without people being in the same group
I don’t hope I am bothering you with my question.
Aucun commentaire:
Enregistrer un commentaire