I operate a football pool for the season (approx 140 entries) Briefly, here
is what it looks like;

Current Name Total points Week One WeekTwo Week Three ect.

1 Joe 35 11 13
11
2 Sam 34 12 12
10
3 Bob 33 12 12
9

What I would like to add is a Column for their standing the previous week,
in this case Week Two. It would hopefully look like this;

Current Previous Name Total Points Week One Week Two
Week Three
1 6 Joe 35 11
13 11
2 4 Sam 34 12
12 10

There will be approx 140 rows and I sort by Total Points

Is this a formula or a macro ?

Thanks

Bob