Thank you so much. The level of effort users are prepared to make to help others is amazing.
You're certainly on the right track, but I believe I may not have been specific enough describing what I'm looking for.
The league placings change after matches are played but there are 12 teams in the league. And teams are playing on different days. So that means fixtures can be played by teams placed lower in the league on a day when higher teams do not play. Meaning the rankings wont start at 1. Eg if the bottom six played each other on the same day and there were no other matches played then that's 3 fixtures and rankings would run from 6 to 12. I'll need to make excel aware of every teams league position before it calculates their new positions. It's surprisingly complex the more you get into it.
I tackled it with VBA, and couldn't get it working properly. Now I'm going to have a go with python. If I can't accurately calculate the league positions with that I'll have to break the spreadsheet down and calculate league placings in their own worksheet. That'll be a huge pain in the backside.
Thanks again for your time and input. I really appreciate it.