I run a football (soccer) league which is kept upto date using Excel. What I would like to do is have a column showing what position a team has moved from. For eg:
Team A last week were in 4th position. This week they have moved down to 7th.
Column B will show all positions in order 1 through to 10
I would like column A to show last weeks position for each team.
Any ideas???
Team A last week were in 4th position. This week they have moved down to 7th.
Column B will show all positions in order 1 through to 10
I would like column A to show last weeks position for each team.
Any ideas???