Need A Random Team List of 26 Teams of 2 that is Unique from the last 25 sets

Copper Contributor

I have 52 names that form 26 teams (of 2). Each week, I need another set of 26 teams, but they must be unique from the last 25 weeks.  Ideally, the final output should be similar to the "Monthly Team Rotation" calendar below or easily pasted into the sheet below.

Monthly Team RotationMonthly Team Rotation

4-Month Rotation4-Month Rotation

0 Replies