SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Another thought:
For each group you could use RANK and MODE to determine whether a tiebreak was required. If there is an error in MODE, all teams are ranked. No problem. If the mode is 1 or 2, you need to separate the teams on a tiebreak.
Denis
For each group you could use RANK and MODE to determine whether a tiebreak was required. If there is an error in MODE, all teams are ranked. No problem. If the mode is 1 or 2, you need to separate the teams on a tiebreak.
Denis