Hi All, I am looking to produce a small fixture list spreadsheet with 6 teams that play each other twice.

I think I can just about manage to produce the fixture list generator but Team 1 and Team 5 for this league are 'rivals' so if one is at home the other would play away. (Similar to Liverpool and Everton in the english football/soccer league).

Can anyone point me in the right direction as to what function I would use for this? or just any other info about this topic.

Thanks

Wayne