I am struggling to find a way to solve the problem below and wondered if anyone has any ideas on the best way to solve this.
I have a number of people, lets say 40 to start with, attending a meeting where there are 4 groups of 10 people.
The goal is for the 40 people in the room, each will attend 4 separate rounds of group meetings of 10 people in each group so when they walk out the door after the 4 group meetings they will have said hello to all 39 other people.
is there a way to either use a formula or VBA to quickly visualise this in a table?
TIA
I have a number of people, lets say 40 to start with, attending a meeting where there are 4 groups of 10 people.
The goal is for the 40 people in the room, each will attend 4 separate rounds of group meetings of 10 people in each group so when they walk out the door after the 4 group meetings they will have said hello to all 39 other people.
is there a way to either use a formula or VBA to quickly visualise this in a table?
TIA