Scheduling Eight People

[lzrdlvr]

I have eight tellers and each Saturday, two of them work together at the drive-up bank. I need to create a schedule so that they are on a rotation but also so that they don't work with the same person every week. Let's say their names are Gabrielle, Pam, Kayla, Susan, Michelle, Catherine, Shannon, and Barbara. For example, the first Saturday, Gabrielle and Pam would work together. Then the next Saturday, Kayla and Susan would work together. Then Michelle and Catherine...and so on. I can easily figure out the first rotation but am getting stuck after that. I like to figure these things out on my own but time is of the essence so I'm asking for help. thank you in advance!!

[NickyC]

Hi
try this
the shaded cells in the grid indicate areas you should not fill in
enter numbers 1 to 7 (for each week) in the unshaded areas, picking numbers which have not already occurred in that row(person 1) or column (person2)
the udf:

Please Login or Register  to view this content.

double checks that the person in that row/column does not already have a partner for that week

[lzrdlvr]

Thank you so much NickyC! This will work great for what I need