# Help with league stats

#### lascough

##### Board Regular
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???

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Richard Schollar

##### MrExcel MVP
So do you maintain a list somewhere in this workbook showing what position the team was in each week, or does historical position data get 'lost' every week there is a new set of results to record? Where do you record the results? Do you have each week's results and are they listed sequentially?

#### lascough

##### Board Regular
League Table Help

To be honest, it is a very simple worksheet. The points are manually entered then I do a sort to put them in order.
The historical data get lost every week although if there is a way to record the weekly positions I could have a use for this information.

#### Richard Schollar

##### MrExcel MVP
I think you'd be best advised to record each team's results on a weekly basis and then use this data to build the League table. Then you have full history and can go back to a specific week's results/League positions if required. Doesn't have to be anything fance, even just having the week number and Win/Loss/Draw against team name should suffice.

#### njimack

##### Well-known Member
Don't know how useful this will be, but there are some amazing league tables at www.michaelwray.co.nz

#### Mombuca

##### Board Regular
Well, i think you must copy a value column b to a before update column b.

Replies
0
Views
278
Replies
0
Views
302
Replies
9
Views
446
Replies
4
Views
427
Replies
2
Views
1K

1,190,624
Messages
5,981,998
Members
439,750
Latest member
creaseA

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back