Hi Kaper,
Thank you for replying and with so much feedback and obvious time spent looking at this. Yes, I've tried the way you described also. The attachment I posted was the way I had found the file online without any of the attempts I've made in changes. The one thing I have seen is that to do a round robin like this at all, the first team has to remain a constant in the first column as does the formula layout in the first row. My stubborness is kicking in on this... It seems like there "should" be a way to do it, some pattern that could be followed and all I need to do is find that pattern. But, I agree with you that having some irregularity may be the best I'll be able to come up with. I've been able to accomplish the Home and Away rotation with an odd number of teams but even is a completely different story...
Thanks again for helping. I'm going to let this post stay on here for a while in case anyone else has any ideas.
Cheers!
Bookmarks