If you had 4 groups of people, 50ppl in total, with a different number in each group, and you wanted to match them with another person outside the group to meet on a 2wkly basis, how would you randomise it?
My thought is to randomise the order of the people in each group and then have a fixed formula to pair them up.
Properly (well not properly but real random stuff is expensive) random would be pretty easy. I'd probably use randbetween to get your random number and pair on that.
You might end up with the same pair 3 times in a row or something though if you're doing properly random
If you had 4 groups of people, 50ppl in total, with a different number in each group, and you wanted to match them with another person outside the group to meet on a 2wkly basis, how would you randomise it?
My thought is to randomise the order of the people in each group and then have a fixed formula to pair them up.