League Table Based on Head to Head results

**darkblueblood** · 02-11-2014, 11:07 AM

General Football Season with Fixtures Creator V1.1.zip

I have the attached fixture generator and league table spreadsheet that I downloaded to incorporate in a project I'm doing. I've gone through the standings and fixtures pages, and I'm fairly happy with the way the league placings are calculated.

However, does anyone know how to base league placings on the head to head match between 2 teams? At the moment it's based on:

- Points
- Goal Difference
- Goals Scored
- Last years placing

I would like to include the first 3 in that order, but instead of the final criteria being last years placing, I would like it to look at the games between the teams who are equal (if they are equal), and place them in league order based on this.

Does anyone know how I would go about this?

Thanks in advance

**bsalv** · 02-11-2014, 01:24 PM

I deleted some sheets to reduce the size of the file.
I use this function for the poules for the next WorldCup in Brasil.
So the ranking is made by the rules for Brasil.
1. the points
2. the difference in goals
3. the goals made
in case of equal ranking the results of the games between those teams
4. the points
5. the difference in goals
6. the goals made

This function can be adapted to your situation.

**scousemo** · 01-16-2023, 06:41 AM

Is there a way that you can have mutiple fictures generated from just a head to head league?

**AliGW** · 01-16-2023, 07:10 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread