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

Thanks

Nik

 

[Fenrirshowl]

Hi Nik

You obviously need to refer to some other data. Can you provide examples of what you have to work with?

Fen

 

[niknik24]

Hi

Yeah i have a results section in my spreadsheet, 1 result per row.
England 1 0 Estonia
Each team plays 12 times and there are 7 teams in the league. from there i have a few specific stages i go through to begin calcualting my league. The problem arises obviously when the teams end up with the same amount of points. I can't think of a function that will lookup the relevant teams' match and decipher from there.

 

[Fenrirshowl]

Doesn't that mean you need to check two results in the event of a tie (england v estonia and estonia v england)?

 

[niknik24]

Hello

Yes thats correct, they play twice

Thanks

 

[Fenrirshowl]

And then it goes to total goal difference or goals scored?

 

[Fenrirshowl]

....in the event of both home wins, that is.

 

[niknik24]

yeah that right, after the games in question results it goes to goal difference.

thanks

 

[Fenrirshowl]

Ok...I'm thinking about it, but have to appear as though I am working at the same time so their might be a bit of wait (unless someone comes up with an answer in the meantime). I think you will need "W/L/D" column to make things easier and an additional column of "EnglandEstonia" and "EstoniaEngland" type results for lookup purposes.

 

[niknik24]

Thanks very much, no worries about the wait. I don't have internet away from work so but am back monday if needs be. Appreciate the help a lot

thanks

Nik

 

[Fenrirshowl]

I Will try to sort out an answer by Monday morning

 

[niknik24]

cheers