ranking ex eaquos

[Bossie]

I'm organizing a quiz and need a good (formula? vba?) to rank the teams.
The general rule is: when two teams have the same score, we go back to the first round. If they both score the same in round 1, we check round 2, etc...

In the attached file you see my solution.

Problem is, excel rounds its numbers, so I can only use this method for a quiz of mximum 12 rounds (after 13 excel does some roundig so the difference is gone)

Any ideas on how I can solve this problem?

 

[NARAYANK991]

Hi ,

How many rounds do you want to cater to ? 13 , 14 , 15 ,... ?

Narayan

 

[Bossie]

Hey Narayan,

thanks for looking in to this problem.
Currently the maximum rounds is 15. Is that important?

grtz
Hugo

 

[NARAYANK991]

Hi ,

See if you can apply this technique to your full set of participants over 15 rounds ; let us see whether it fails or works.

Narayan

 

[Bossie]

hi,

all goes well until round 10. Once you add round 11...
I updated the file, so you can see that from round 11 on, my system fails...

grtz

Hugo

 

[NARAYANK991]

Hi ,

I think you have not gone through the file I uploaded with my first comment.

See this one. I have used the technique in the tab named round12.

Narayan

 

[Bossie]

My apologies, indeed I didn't see the attached file.
But now I did and it is awesome.
Thank you very much!

 

[Bossie]

Hi again,

I added a last multiplication, and now it works perfect.

(see attached file)

thx again!

 

[NARAYANK991]

Hi ,

If you go up to the full set of participants and rounds , and find a problem , you can try changing the value of the constant in cell I1 from 2 to another value , say 7.

The limitation is that the overall number which results from the multiplications cannot exceed 15 digits.

Narayan