mardi 28 août 2018

How to randomly create 6 groups of 5 people 4 times without any person being in a group with another person twice

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