Non-overlapping Group Creation / Macro

[canadian86]

Hi everyone

I am doing a virtual networking session with “x” number if people tonight. Let’s assume X = 15.

I want to break up the entire group in teams of “y”. Let’s say y = 3.

So in Round 1, I would have 3 teams of 5.

In Round 2, I also want 3 teams of 5; however, I want each team to have DIFFERENT team members vs their Round 1 team.

The intent is that I want as many rounds as I can get where all participants are getting to meet as many other participants as possible, thus The model needs to reduce overlapping.

is there a way to automate this in Excel?

thanks!

 

[Chaozfate]

HI,

You may want to try this, the non-excel way

Random Team Generator - Keamk

Keamk, the ultimate random team generator. Set participants. Set teams. And then, let Keamk do the rest.

www.keamk.com

or the excel way

Random Group Generator Template [Free Download]

Download Free Random Group Generator Template to quickly divide a list of students/participants into groups. All you need to do is specify number of groups.

trumpexcel.com