My family participates in a pinochle tournament that requires all the players to be paired in 3 person teams that switch each round. The tournament consists of 10 rounds. Unfortunately, the number of players fluctuates, so the pairing will not always be divisible by 3. In this case, it is customary to use as many 4 person teams as necessary, but not less than 3 people can be on a team.
I've seen Visual Basic programs that can generate pairing based on a list on names in column A, but I can't seem to locate it anywhere. Ideally, I intend to create a basic sheet to list the names and incorporate a command button to generate the pairings on the spot.
Any help would be extremely appreciated.
Bookmarks