O
Originalgoth
Hi All & Happy Christmas & New Year,
How can I sort a league table and have the formulas move to the new cells?
I'm working on a World Cup Spreadsheet.
I've got each table as below
a b c d e f g h i
P W D L F A Pts GD
Team A c3 c4
Team B
Team C
Team D
The fixtures are below each table and the results of these are what develops
the table.
E.G.
For Team A won in C3 I've got =SUM(A11+A15+K21)
Team A Draw in C4 I've got =SUM(B11+B15+L21)
The above cells are static (don't move) and will either contain 1 or 0.
When I sort the league table, the teams move but this makes the formulas get
messed up - if Team D moves to 1st place in the table (move up 3 places), the
formulas refer to 3 cells above the originals so that's not right - I need
the formulas to always refer to the original cells.
Thanks for any answers & help in advance
John
How can I sort a league table and have the formulas move to the new cells?
I'm working on a World Cup Spreadsheet.
I've got each table as below
a b c d e f g h i
P W D L F A Pts GD
Team A c3 c4
Team B
Team C
Team D
The fixtures are below each table and the results of these are what develops
the table.
E.G.
For Team A won in C3 I've got =SUM(A11+A15+K21)
Team A Draw in C4 I've got =SUM(B11+B15+L21)
The above cells are static (don't move) and will either contain 1 or 0.
When I sort the league table, the teams move but this makes the formulas get
messed up - if Team D moves to 1st place in the table (move up 3 places), the
formulas refer to 3 cells above the originals so that's not right - I need
the formulas to always refer to the original cells.
Thanks for any answers & help in advance
John