Hi ptmuldoon,

I've struggled with this problem in the past also. I agree with Dave above in that 10 weeks with 20 players might not be possible.

In my structure, we would have different people sign up for our Wed Night Match Play event and the rules were similar. No two people should play against each other for the season. I think this is your problem also.

See the attached "Master" that I've been working on for many years and look at the Teams Tab and at cell V4. When you double click on that cell it runs code trying to create pairings that have no duplicates. I use past play on the Rounds Tab. The code randomly selects the players who have an X (20 in your case) and then calls a "LeastPlayed" subroutine 20 times in my code. It keeps the smallest number of "PlayedBefore" as the answer. If you don't like it simply double click on V4 a second or third time for more tries. My attack on this problem is to use random pairings and keep the smallest number of overlaps. If you want, you can study my workbook and follow the code to see what I'm doing. The entire file is too large to post, so I need to trim it a lot. See the attached xlb and see if you can save and open it.
2017 Wed Mens Match After Rnd 10.xlsb