Soccer Ligue

[Caribeiro77]

Hy guys need help on a tricky one, i guess

TEAM 1	21	X	18	TEAM 2
TEAM 3	15	X	21	TEAM 4
TEAM 1	16	X	21	TEAM 3
TEAM 2	21	X	16	TEAM 4
TEAM 4	21	X	16	TEAM 1
TEAM 3	21	X	12	TEAM 2

<tbody>
</tbody>

I now need to rank them, this is what i have so far and is not correct)

TEAM	G	W	L	PTS +	PTS -	DP	PTS
TEAM 3	3	2	1	57	49	8	6
TEAM 4	3	2	1	58	52	6	6
TEAM 1	3	1	2	53	60	-7	3
TEAM 2	3	1	2	51	58	-7	3

<tbody>
</tbody>

the criteria to tiebrakes are

1 - Result in the game times played against each other
2 - Goal avarage
3 - Pts -


In this case the positions should be:

TEAM	J	V	D	PTS +	PTS -	DP	PTS
TEAM 4	3	2	1	57	49	8	6
TEAM 3	3	2	1	58	52	6	6
TEAM 1	3	1	2	53	60	-7	3
TEAM 2	3	1	2	51	58	-7	3

<tbody>
</tbody>

TEAM 4 have to be in 1st place because they have the same points TEAM 3 and they won the game against TEAM 3, the same happen's with TEAM´S 1 and 2, they have the same points but TEAM 1 won the game against TEAM 2
What i need is a formula or VBA to PTS column.

Thanks in advance

 

[Caribeiro77]

Can someone help?
Thank you..