--a---b---c---d
1 1 utds star ?
2 2 city utds ?
3 3 colt colts ?
4 4 star city ?
Positions in league.
col b is the position and is fixed.
col c is pasted in as current and changes.
In row D I need the results to be as below and to change when i paste in again.
1) -1 i.e have dropped a place
2) -2 have dropped 2 places
3) 0 stayed same
4) +3 move up 3
Cheers peter
1 1 utds star ?
2 2 city utds ?
3 3 colt colts ?
4 4 star city ?
Positions in league.
col b is the position and is fixed.
col c is pasted in as current and changes.
In row D I need the results to be as below and to change when i paste in again.
1) -1 i.e have dropped a place
2) -2 have dropped 2 places
3) 0 stayed same
4) +3 move up 3
Cheers peter
