Football League Table Spreadsheet

[gracust]

Hi,

Forgive me if I have posted in the wrong section but it is my first post.
I am looking to use a spreadsheet to contain a league table and fixture list for a church league which has ten teams playing each other twice in a season.
I want to be able to just add the scores in to the fixture list and have the table update itself accordingly. I want the table to have columns for the following:
Played/Won/Lost/Drawn/Goals For/Goals Against/Goal Difference/Points
I will be using Excel 2002.

Many thanks...Gracust

 

[GorD]

Hi and welcome to the board.

Hopefully this will do what you need. Post is in two halves due to limitation of message size.

Fixture list housed in cells A1:f8 for this example

Book1
	A	B	C	D	E	F
1		Fixtures
2	Played	HOME			AWAY	Played
3	1	Team1	2	0	Team2	1
4	1	Team3	1	3	Team4	1
5	1	Team5	1	1	Team6	1
6		Team7			Team8
7	1	Team9	1	4	Team10	1
8	1	Team4	2	2	Team1	1
Sheet1

once set up column A and F can be hidden if required

 

[GorD]

Then the assoociated league table:

Book1
	H	I	J	K	L	M	N	O	P	Q	R
2			Team	Played	Won	Lost	Drawn	Goals+	Goals-	GoalsDelta	Points
3	1		Team4	2	1	0	1	5	3	2	4
4	2		Team1	2	1	0	1	2	2	0	4
5	3		Team10	1	1	0	0	4	1	3	3
6	4		Team5	1	0	0	1	0	0	0	1
7	5		Team6	1	0	0	1	0	0	0	1
8	6		Team7	0	0	0	0	0	0	0	0
9	7		Team8	0	0	0	0	0	0	0	0
10	8		Team2	1	0	1	0	0	0	0	0
11	9		Team3	1	0	1	0	0	0	0	0
12	10		Team9	1	0	1	0	0	0	0	0
Sheet1

note the empty column i, to allow sorting of teams but leave position


Hope this helps

P>S it can probably be done better

 

[GorD]

There was an error in the goals for against due to the ranges not being locked before copying down . Try this

Book1
	H	I	J	K	L	M	N	O	P	Q	R
2			Team	Played	Won	Lost	Drawn	Goals+	Goals-	GoalsDelta	Points
3	1		Team4	2	1	0	1	5	3	2	4
4	2		Team1	2	1	0	1	4	2	2	4
5	3		Team10	1	1	0	0	4	1	3	3
6	4		Team5	1	0	0	1	1	1	0	1
7	5		Team6	1	0	0	1	1	1	0	1
8	6		Team7	0	0	0	0	0	0	0	0
9	7		Team8	0	0	0	0	0	0	0	0
10	8		Team3	1	0	1	0	1	3	-2	0
11	9		Team2	1	0	1	0	0	2	-2	0
12	10		Team9	1	0	1	0	1	4	-3	0
Sheet1

 

[gracust]

GorD,

Many thanks for your swift reply and help. I will give it a go.

Kind regards...Gracust