Firstly thank you to edvwvw, MarvinP, oldchippy, and especially ChemistB with all the help on my "Conditional Formatting" thread, it works a treat.

Now another quick question is there a way I can split a league table into two without making two separate tables?

I'll try and explain better my Scottish Premier League spreadsheet after the first 33 matches the table splits in two where the top six teams play each other a further once as do the bottom teams, but no teams can leapfrog each other (e.g. if say Motherwell were 6th with 39 points in 6th position and St Johnstone were 7th with 41 points they'd remain in the same positions) - is this possible?