Table Formulae

Hi, I am trying to set up a football league table. Iam ok with most of the formulae to arrive at a points total. However when the points total of two or more teams is the same then the final position is governed by goal difference. Can someone please help with this formula?

Originally Posted by Spencer101

Can you post an example of what you have so far? Makes it far easier to help that way.

In accordance with forum rule#1, you may wish to change the thread title to something a bit more descriptive of your issue.

11 Norwich 12 2 2 2 10 9 1 2 3 7 13 -5 13
12 Everton 11 2 1 3 7 8 2 0 3 6 8 -3 13

The goal difference figures of -3 and -5 mean the two teams should be in reverse position to show their correct position in the table

Originally Posted by Ron12

Hi, I am trying to set up a football league table. Iam ok with most of the formulae to arrive at a points total. However when the points total of two or more teams is the same then the final position is governed by goal difference. Can someone please help with this formula?

11 Norwich 12 2 2 2 10 9 1 2 3 7 13 -5 13
12 Everton 11 2 1 3 7 8 2 0 3 6 8 -3 13

Originally Posted by Ron12

Hi, I am trying to set up a football league table. Iam ok with most of the formulae to arrive at a points total. However when the points total of two or more teams is the same then the final position is governed by goal difference. Can someone please help with this formula?

Home Away Goal
Position Name Played Won Drawn Lost For Against Won Drawn Lost For Against Diff. Points
1 Man. City 12 6 0 0 19 3 5 1 0 23 8 31 34
2 Man. Utd 12 5 0 1 18 9 4 2 0 11 3 17 29
3 Newcastle 12 4 2 0 10 5 3 2 1 8 6 7 25
4 Chelsea 12 4 0 2 16 11 3 1 2 9 6 8 22
5 Tottenham 10 3 0 1 12 7 4 1 1 15 8 12 22
6 Liverpool 12 2 4 0 10 4 4 0 2 11 6 11 22
7 Arsenal 12 5 0 1 12 4 2 1 3 13 18 3 22
8 Aston Villa 11 3 2 1 10 6 0 4 1 6 9 1 15
9 QPR 12 1 3 2 5 9 3 0 3 8 13 -9 15
10 West Brom 12 2 1 3 5 6 2 1 3 6 11 -6 14
11 Norwich 12 2 2 2 10 9 1 2 3 7 13 -5 13
12 Everton 11 2 1 3 7 8 2 0 3 6 8 -3 13
13 Swansea 12 3 2 1 8 2 0 2 4 4 14 -4 13
14 Stoke 12 2 2 2 7 7 1 1 4 3 15 -12 12
15 Sunderland 12 1 3 2 9 7 1 2 3 5 6 1 11
16 Fulham 12 1 3 2 11 9 1 2 3 3 6 -1 11
17 Wolves 12 2 1 3 8 10 1 1 4 5 10 -7 11
18 Bolton 12 1 0 5 9 17 2 0 4 10 12 -10 9
19 Blackburn 12 1 0 5 6 13 0 4 2 10 14 -11 7
20 Wigan 12 1 2 3 8 11 0 1 5 2 12 -13 6






Home Away Goal
Position Name Played Won Drawn Lost For Against Won Drawn Lost For Against Diff. Points
1 Man. City 12 6 0 0 19 3 5 1 0 23 8 31 34
2 Man. Utd 12 5 0 1 18 9 4 2 0 11 3 17 29
3 Newcastle 12 4 2 0 10 5 3 2 1 8 6 7 25
4 Chelsea 12 4 0 2 16 11 3 1 2 9 6 8 22
5 Tottenham 10 3 0 1 12 7 4 1 1 15 8 12 22
6 Liverpool 12 2 4 0 10 4 4 0 2 11 6 11 22
7 Arsenal 12 5 0 1 12 4 2 1 3 13 18 3 22
8 Aston Villa 11 3 2 1 10 6 0 4 1 6 9 1 15
9 QPR 12 1 3 2 5 9 3 0 3 8 13 -9 15
10 West Brom 12 2 1 3 5 6 2 1 3 6 11 -6 14
11 Norwich 12 2 2 2 10 9 1 2 3 7 13 -5 13
12 Everton 11 2 1 3 7 8 2 0 3 6 8 -3 13
13 Swansea 12 3 2 1 8 2 0 2 4 4 14 -4 13
14 Stoke 12 2 2 2 7 7 1 1 4 3 15 -12 12
15 Sunderland 12 1 3 2 9 7 1 2 3 5 6 1 11
16 Fulham 12 1 3 2 11 9 1 2 3 3 6 -1 11
17 Wolves 12 2 1 3 8 10 1 1 4 5 10 -7 11
18 Bolton 12 1 0 5 9 17 2 0 4 10 12 -10 9
19 Blackburn 12 1 0 5 6 13 0 4 2 10 14 -11 7
20 Wigan 12 1 2 3 8 11 0 1 5 2 12 -13 6







Home Away Goal
Position Name Played Won Drawn Lost For Against Won Drawn Lost For Against Diff. Points
1 Man. City 12 6 0 0 19 3 5 1 0 23 8 31 34
2 Man. Utd 12 5 0 1 18 9 4 2 0 11 3 17 29
3 Newcastle 12 4 2 0 10 5 3 2 1 8 6 7 25
4 Chelsea 12 4 0 2 16 11 3 1 2 9 6 8 22
5 Tottenham 10 3 0 1 12 7 4 1 1 15 8 12 22
6 Liverpool 12 2 4 0 10 4 4 0 2 11 6 11 22
7 Arsenal 12 5 0 1 12 4 2 1 3 13 18 3 22
8 Aston Villa 11 3 2 1 10 6 0 4 1 6 9 1 15
9 QPR 12 1 3 2 5 9 3 0 3 8 13 -9 15
10 West Brom 12 2 1 3 5 6 2 1 3 6 11 -6 14
11 Norwich 12 2 2 2 10 9 1 2 3 7 13 -5 13
12 Everton 11 2 1 3 7 8 2 0 3 6 8 -3 13
13 Swansea 12 3 2 1 8 2 0 2 4 4 14 -4 13
14 Stoke 12 2 2 2 7 7 1 1 4 3 15 -12 12
15 Sunderland 12 1 3 2 9 7 1 2 3 5 6 1 11
16 Fulham 12 1 3 2 11 9 1 2 3 3 6 -1 11
17 Wolves 12 2 1 3 8 10 1 1 4 5 10 -7 11
18 Bolton 12 1 0 5 9 17 2 0 4 10 12 -10 9
19 Blackburn 12 1 0 5 6 13 0 4 2 10 14 -11 7
20 Wigan 12 1 2 3 8 11 0 1 5 2 12 -13 6

Sorry about the The data is entered manually and sorted via formula.

Originally Posted by Spencer101

Erm.. thanks for that but showing the full tables in text format doesn't really help with any of the questions I asked above.

We need to see the actual workbook! i.e. attach the workbook!

Sorry having difficulty attaching the workbook

Originally Posted by Spencer101

What formulas do you use to sort the data?

The formulas shown in excel book. I dont know of any other way

If you let have an email address I will try and send the workbook that way