# Creating random groups of people

#### Shannon1027

##### New Member
I tried to search for a solution to my problem, but I wasn't sure exactly what to search. So if the answer is already out there, I apologize.

I am organizing business roundtables, where business owners come to meet each other. During any given meeting there can be any number of people, tables, and rounds (where guests change tables to meet each other).

What I need is a way to input the number of people, the number of tables, and the number of rounds and get in return a list for each guest of which table they will visit during each round so they don't see the same people more than once. The column headers would be something like this, with the table number listed in the cells below the rounds.

Guest, Round1, Round2, Round3, Round4, Round5, etc.

Typical attendance is around 100 people and there are usually 10 - 14 tables. So the list would be pretty extensive. Thanks for any help you can provide.

Shannon

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Anyone?

#### tusharm

##### MrExcel MVP
Take a look at how 'duplicate bridge' is played...or accurately how it is organized. It uses the same concept in having pairs moving from table to table competing with each other. Of course, each table in bridge has only 2 pairs so I don't know how well that will work but I'll leave that analysis to you.
I tried to search for a solution to my problem, but I wasn't sure exactly what to search. So if the answer is already out there, I apologize.

I am organizing business roundtables, where business owners come to meet each other. During any given meeting there can be any number of people, tables, and rounds (where guests change tables to meet each other).

What I need is a way to input the number of people, the number of tables, and the number of rounds and get in return a list for each guest of which table they will visit during each round so they don't see the same people more than once. The column headers would be something like this, with the table number listed in the cells below the rounds.

Guest, Round1, Round2, Round3, Round4, Round5, etc.

Typical attendance is around 100 people and there are usually 10 - 14 tables. So the list would be pretty extensive. Thanks for any help you can provide.

Shannon

#### Shannon1027

##### New Member
Thanks! In researching the duplicate bridge I found out that what I have is a social golfer problem. If anyone has any insight on how to best solve a problem of that nature, I would be very appreciative.

#### tusharm

##### MrExcel MVP
Searched google for "social golfer?" I found what I thought were several good leads.

Replies
14
Views
823
Replies
2
Views
646
Replies
0
Views
473
Replies
0
Views
345
Replies
0
Views
474

1,195,716
Messages
6,011,276
Members
441,598
Latest member
chrispaulpearce

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back