Hello.
In any given set of fixtures, I want to enter each home team in column X and each away the team in column Y.
Is there a way to have the Home Strength calculation show in columns Z and the Away Strength calculation show in columns AA without having to do it manually?
Each home team's strength number is determined by multiplying the home attacking strength (HAS) in column T with the away defensive strength (ADS) in column W with Cell H30 (T*W*H30)
Each away team's strength is worked out by multiplying the away attacking strength (AAS) in column V with the home defensive strength (HDS) in column U with Cell Q30 (V*U*Q30)
Thank you.
Bookmarks