Hello all,
I have a list of 102 people in my organization who need to "get to know eachother" by going on "speed dates" with eachother. 102 people getting to know eachother during 1 on 1's would mean a lot of meetings which would cost a lot of time, so the idea of my organization is to organize lunch settings in groups of 6. So every week there will be a lunch session where all 102 people are matched in groups of 7 ( = 17 groups) so that during 1 session you will automatically get to know 5 new people. The goal is that by the end of the year, everyone has had one speed-date session with everyone on the list. That means that per lunch session, each person will meet with 5 other persons. The next week, another lunch session will be held, and everyone has to be matched up with 5 new/different persons in order to make the session as efficient as possible.
That means that each lunch session, there will be 17 groups of 6 people ( = 102). The next week, the same group of 102 has to be split up in 17 new groups, but everybody has to be matched up with only new faces, so nobody from Round 1 can be in the same group again. The week after that, the same principle applies again, and nobody can be matched up with anyone they have been matched up already during week 1 or week 2.
Basically, I'm looking for a way that Excel generates 17 groups of 6 people from the list of 102 for a number of "rounds" until everyone has been grouped with everyone once. At the same time I want to prevent that people get matched up with the same people in different rounds that they have already had a lunch session with.
My list is a flat list of 102 names that are listed in column A so in Cell A1:A102\
Does anyone know a quick/smart/easy way to fix this in Excel? Thanks in advance!
I have a list of 102 people in my organization who need to "get to know eachother" by going on "speed dates" with eachother. 102 people getting to know eachother during 1 on 1's would mean a lot of meetings which would cost a lot of time, so the idea of my organization is to organize lunch settings in groups of 6. So every week there will be a lunch session where all 102 people are matched in groups of 7 ( = 17 groups) so that during 1 session you will automatically get to know 5 new people. The goal is that by the end of the year, everyone has had one speed-date session with everyone on the list. That means that per lunch session, each person will meet with 5 other persons. The next week, another lunch session will be held, and everyone has to be matched up with 5 new/different persons in order to make the session as efficient as possible.
That means that each lunch session, there will be 17 groups of 6 people ( = 102). The next week, the same group of 102 has to be split up in 17 new groups, but everybody has to be matched up with only new faces, so nobody from Round 1 can be in the same group again. The week after that, the same principle applies again, and nobody can be matched up with anyone they have been matched up already during week 1 or week 2.
Basically, I'm looking for a way that Excel generates 17 groups of 6 people from the list of 102 for a number of "rounds" until everyone has been grouped with everyone once. At the same time I want to prevent that people get matched up with the same people in different rounds that they have already had a lunch session with.
My list is a flat list of 102 names that are listed in column A so in Cell A1:A102\
Does anyone know a quick/smart/easy way to fix this in Excel? Thanks in advance!
