canadian86
Board Regular
- Joined
- Feb 6, 2011
- Messages
- 53
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!
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!