this may not be possible but then again.
I have attached a spreadsheet that contains 3 grids.
The grid on the left contains letters A-X [representing players] and both Rinks and positions [Rinks across the top 1-4 Positions going down 1-3
The middle grid is made up of Names that corolate to the positions in the grid on the left
The grid on the right has Names and their respective letter
What I am trying to do is fill in the grid on the left so that
1) Each letter will end up in each rink once and two of the rinks twice [that is because there are 6 games and 4 rinks]
2) Each letter will be in each position twice [in either the top group of three [home team] or bottom group of 3 [Away Team
3) Each letter [player] will play against different people where possible
in the attached file you will see that person K plays against person W in each game. This is what I am trying to avoid.
Is there a formula that will work this out or if not maybe an expert that can work it out for me.