# Create three person groupings with no duplicates

1. ## Create three person groupings with no duplicates

I have a work department with 27 total employees, 9 in three different regions. My goal is to group employees from one region with each of the other employees from the other two regions, over the next 9 months creating as few duplicates as possible. I believe I will need to have groups of three each month. For example, #1 San Diego employee, #1 Charlotte employee and #1 remote employee, then the next month #1 SD, #2 CLT, #2 Remote. With the goals to create unique three employee groupings for the next 9 months with each employee from one region, being paired with each employee from the other two regions. Hopefully this makes sense. Any ideas?

2. ## Re: Create three person groupings with no duplicates

Without much thought,

 Row\Col A B C D E F G 1 SAN CLT Rem SAN CLT Rem 2 SAN1 CLT1 Rem1 SAN2 CLT3 Rem4 3 SAN2 CLT2 Rem2 SAN3 CLT4 Rem5 4 SAN3 CLT3 Rem3 SAN4 CLT5 Rem6 5 SAN4 CLT4 Rem4 SAN5 CLT6 Rem7 6 SAN5 CLT5 Rem5 SAN6 CLT7 Rem8 7 SAN6 CLT6 Rem6 SAN7 CLT8 Rem9 8 SAN7 CLT7 Rem7 SAN8 CLT9 Rem1 9 SAN8 CLT8 Rem8 SAN9 CLT1 Rem2 10 SAN9 CLT9 Rem9 SAN1 CLT2 Rem3

3. ## Re: Create three person groupings with no duplicates

I did more than the 9 months. I got carried away. Did all combinations.

There are two lookup tables. One in column G the other in columns H:Y.

The combinations are in columns AC:AE. They are in sort order because that's how the formulas did it. Sorry about that.

Column AC
Formula:
`Please Login or Register  to view this content.`
TeamLookup is in G4:G12.

Formula:
`Please Login or Register  to view this content.`
MasterLookup is in H4:Y12.

Column AE
Formula:
`Please Login or Register  to view this content.`

The file is attached. Edit Ignore the column of dates. I intended to use them in a grouping strategy; got tired and forgot it.

4. ## Re: Create three person groupings with no duplicates

Please disregard my previous post. I got lost in the brush piles of my mind.......trying something else.

Edit Try this instead. There is a named lookup table in columns AU:CB.

This formula in E3 filled down and across to AM11; schedules 9 months.
Formula:
`Please Login or Register  to view this content.`
I didn't do a painstaking check but I didn't manage to find any duplicate teams.

The file is attached.

5. ## Re: Create three person groupings with no duplicates

FlameRetired, you are awesome and much smarter than I am! This forumla and spreadsheet works great, thank you!

6. ## Re: Create three person groupings with no duplicates

You're welcome. Glad it works. Thanks for the rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)