Looking for a way to automate scheduling duos into different squads

bsweet0us

New Member
Joined
Apr 12, 2008
Messages
38
Office Version
  1. 365
Platform
  1. Windows
I have a worksheet that lists qualifying teams (always 2 people) and I need to schedule them into different squads (dates and times). Any individual can qualify with up to four people, so there needs to be a minimum of 7 squads. In addition, each squad has a maximum number of qualifying teams that can be contained within it. Each individual team member can only participate once on any given squad. (If person A qualified with person B and person C, then person A would participate with person B on one squad and person C on a different squad).

The participants are listed in adjoining columns (first team member in A1 and second team member in B1, for example) and I'd like for the output to be on a sheet separated by squads and then participating teams in the same format (side-by-side in cells).

I've attached photos showing a small data sample and the desired output for visual reference.

For this small sample size, let's assume a maximum of five teams per squad.

I hope this information and sample are understandable, but I will respond to questions as required.

Thanks in advance for your help!
 

Attachments

  • Desired output.png
    Desired output.png
    29.1 KB · Views: 16
  • Entrants.png
    Entrants.png
    27.6 KB · Views: 19

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top