Golf paring over multiple tournaments

As a matter of fact, I did some minor test and after several repetitions - there are always some players who during these 12 rounds play 4 or 5 times within one flight with the same player.

See Attached test file - interesting part is table in AP2:CN52 with conditional formatting showing where such situations occur. and summary left to it - sometimes there are sitiutions when the same player is assigned even more frequently to the other sometimes 5 or even 6 times (half of tournaments!). On the other hand vast majority of pairs palyerA and Player B are in the same flight only once or they never meet on green.

@provoersel2: have you chance to look at some macro solutions with more systematic than random assignment - for instance here: http://www.excelforum.com/excel-form...-schedule.html