I wish to record those who played together on Team A in the range E5:L12 by placing a "1" in the intersecting cells. The goal is to keep a record of who has played with whom so we can mix up the people on the teams. I would capture something like this each week on its separate sheet, then sum across sheets so the person doing the pairing of teams can see who has played with another person too many times.
Perhaps I have approached this in the wrong way by using this E5:L12 range idea. If you see a better approach please mention it.
Bookmarks