League Tables

[Roooookie]

Hi, I was wondering if anyone can help - I'm trying to set up a very basic league table, it's just 2 teams - I was wondering if there is a way to enter the scores i.e 4-2 somewhere on the page and the formula will adjust the Goals Scored, Goals Conceded, and Points accumulated (3 for a win, 0 for defeat) columns and then rank the teams by points.

Is this possible? Any idea how I'd go about it?

cheers!

 

[fairwinds]

Welcome to the board!

Does this help?

Should you not get points for a tie?

Book1
	A	B	C	D	E	F	G
1		Team1	Team2			Team1	Team2
2	Game1	4	2		Goals scored	13	11
3	Game2	1	2		Goals conceded	11	13
4	Game3	5	5		Points	6	3
5	Game4	3	2
6	Game5
7	Game6
8	Game7
9	Game8
10	Game9
Sheet2