I have up to 50 golf players (known by name or number) and 12 tournaments during summer period. I want to randomly build golf flights (3 or 4 players), but want to make sure that none will play 2-3 times with the same team-mate during the remaining tournaments.
I have tried multiple ways to start off, but don't have a clue how to solve this in Excel.
Please help !!!