Tie Breaking Rank Problem Excel 97

[niknik24]

Hello

I am trying to create a excel planner for the football euro2008 qualifying tournemant. I have a problem, i am familair with creating league tables using the rank function but this is of no use here. the rules for euro 2008 are that if 2 teams finish with the same points then the results in their previous matches will determine who is above. Meaning that if England have the same amount of points as andorra then the fact that they beat andorra previously means that they will go through ahead of them in the league table.

Does anyone think they can help me with this problem, is their a vba script that can fix this

Thanks

Nik

 

[xlhelp]

Why ask the same question in two forums? or is it fora?

Member- AAAA Association Against Acronym Abusers

 

[taupirho]

Dont worry about it nik, England won't qualify anyway