How would you adapt this to sort subjects into groups so that each subject is sorted into not 1, but N of M groups, (for example assigned to 3 of the 10 total groups available), with no subject appearing more than once in any single group assignment?
Hi Kimberly, thanks for watching! Could you elaborate why you would need this i.e. sorting people into N of M groups? I may look into making a video to explain it in more detail.
@@theexcelhub I think what the above was asking is similar to what I need to know too. If I have 18 groups and need to sort people into 3 of them but not have their names appear more than once in each group?
Say I have 25 people to assign to groups - with the formula in this video if I define a group size of 6 I will end up with 4 groups of 6 and the 5th group will have 1 member. Is there something I can do to define a maximum number of groups and distribute members as evenly as possible across this maximum number of groups? If I wanted maximum 4 groups in my scenario then one group would have 7 members and the other 3 groups would have 6 members. Cheers
Thanks for your video. If the male and female in each group are to be divided equally, how to set it?
How would you adapt this to sort subjects into groups so that each subject is sorted into not 1, but N of M groups, (for example assigned to 3 of the 10 total groups available), with no subject appearing more than once in any single group assignment?
Hi Kimberly, thanks for watching! Could you elaborate why you would need this i.e. sorting people into N of M groups? I may look into making a video to explain it in more detail.
@@theexcelhub I think what the above was asking is similar to what I need to know too. If I have 18 groups and need to sort people into 3 of them but not have their names appear more than once in each group?
Can you please add 2 conditions:
Team members from same team don’t pair
And pairing doesn’t repeat
Say I have 25 people to assign to groups - with the formula in this video if I define a group size of 6 I will end up with 4 groups of 6 and the 5th group will have 1 member. Is there something I can do to define a maximum number of groups and distribute members as evenly as possible across this maximum number of groups? If I wanted maximum 4 groups in my scenario then one group would have 7 members and the other 3 groups would have 6 members. Cheers
Why is mine showing a #VALUE!?
Hi Eunice, which column is showing that for you?