Caribeiro77
Well-known Member
- Joined
- Sep 24, 2010
- Messages
- 1,261
Hy guys need help on a tricky one, i guess
[TABLE="width: 328"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] TEAM 1
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]18
[/TD]
[TD]TEAM 2
[/TD]
[/TR]
[TR]
[TD] TEAM 3
[/TD]
[TD]15
[/TD]
[TD]X
[/TD]
[TD]21
[/TD]
[TD]TEAM 4
[/TD]
[/TR]
[TR]
[TD] TEAM 1
[/TD]
[TD]16
[/TD]
[TD]X
[/TD]
[TD]21
[/TD]
[TD]TEAM 3
[/TD]
[/TR]
[TR]
[TD] TEAM 2
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]16
[/TD]
[TD]TEAM 4
[/TD]
[/TR]
[TR]
[TD] TEAM 4
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]16
[/TD]
[TD]TEAM 1
[/TD]
[/TR]
[TR]
[TD] TEAM 3
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]12
[/TD]
[TD]TEAM 2
[/TD]
[/TR]
</tbody>[/TABLE]
I now need to rank them, this is what i have so far and is not correct)
[TABLE="width: 518"]
<tbody>[TR]
[TD]TEAM
[/TD]
[TD]G
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]PTS +
[/TD]
[TD]PTS -
[/TD]
[TD]DP
[/TD]
[TD]PTS
[/TD]
[/TR]
[TR]
[TD]TEAM 3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]57
[/TD]
[TD]49
[/TD]
[TD]8
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 4
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]58
[/TD]
[TD]52
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]53
[/TD]
[TD]60
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]TEAM 2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]51
[/TD]
[TD]58
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 518"]
<tbody>[TR]
[TD]TEAM
[/TD]
[TD]J
[/TD]
[TD]V
[/TD]
[TD]D
[/TD]
[TD]PTS +
[/TD]
[TD]PTS -
[/TD]
[TD]DP
[/TD]
[TD]PTS
[/TD]
[/TR]
[TR]
[TD]TEAM 4
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]57
[/TD]
[TD]49
[/TD]
[TD]8
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]58
[/TD]
[TD]52
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]53
[/TD]
[TD]60
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]TEAM 2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]51
[/TD]
[TD]58
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 328"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] TEAM 1
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]18
[/TD]
[TD]TEAM 2
[/TD]
[/TR]
[TR]
[TD] TEAM 3
[/TD]
[TD]15
[/TD]
[TD]X
[/TD]
[TD]21
[/TD]
[TD]TEAM 4
[/TD]
[/TR]
[TR]
[TD] TEAM 1
[/TD]
[TD]16
[/TD]
[TD]X
[/TD]
[TD]21
[/TD]
[TD]TEAM 3
[/TD]
[/TR]
[TR]
[TD] TEAM 2
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]16
[/TD]
[TD]TEAM 4
[/TD]
[/TR]
[TR]
[TD] TEAM 4
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]16
[/TD]
[TD]TEAM 1
[/TD]
[/TR]
[TR]
[TD] TEAM 3
[/TD]
[TD]21
[/TD]
[TD]X
[/TD]
[TD]12
[/TD]
[TD]TEAM 2
[/TD]
[/TR]
</tbody>[/TABLE]
I now need to rank them, this is what i have so far and is not correct)
[TABLE="width: 518"]
<tbody>[TR]
[TD]TEAM
[/TD]
[TD]G
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]PTS +
[/TD]
[TD]PTS -
[/TD]
[TD]DP
[/TD]
[TD]PTS
[/TD]
[/TR]
[TR]
[TD]TEAM 3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]57
[/TD]
[TD]49
[/TD]
[TD]8
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 4
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]58
[/TD]
[TD]52
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]53
[/TD]
[TD]60
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]TEAM 2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]51
[/TD]
[TD]58
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 518"]
<tbody>[TR]
[TD]TEAM
[/TD]
[TD]J
[/TD]
[TD]V
[/TD]
[TD]D
[/TD]
[TD]PTS +
[/TD]
[TD]PTS -
[/TD]
[TD]DP
[/TD]
[TD]PTS
[/TD]
[/TR]
[TR]
[TD]TEAM 4
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]57
[/TD]
[TD]49
[/TD]
[TD]8
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 3
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]58
[/TD]
[TD]52
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]TEAM 1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]53
[/TD]
[TD]60
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]TEAM 2
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]51
[/TD]
[TD]58
[/TD]
[TD]-7
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
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