Given the team list below, the challenge before you is to align teams RANDOMLY under Group A and Group B where one team faces another and there is no repetitions of the team. The formula should be flexible, in case, team list increases / decreases. The team list will always be even as if number of teams is odd, then one team will be left out.
The related Excel file can be downloaded from here Team Pairing
Note – You may choose to post your response in comments.