# Olympic Medal Table Ranking Formula

1. ## Olympic Medal Table Ranking Formula

Hi guys, I want to create an Olympic medal table with the rankings. For that I need a formula to rank countries. U may know the conditions in ranking.For those who are not familiar I'll describe. First the rankings are done according to the number of GOLD medals, if there are ties number of SILVER medals are taken into account. If they tie too, BRONZE medals are involved in rankings. If all the medals are equal then the rank is a tie too. I'll give an example.

RANK COUNTRY GOLD SILVER BRONZE

1 Country A 10 5 3
2 Country B 7 8 4
3 Country C 7 3 9
4 Country D 5 4 6
5 Country E 5 4 3
6 Country F 3 4 0
6 Country G 3 4 0
8 Country H 0 3 2

2. ## Re: Olympic Medal Table Ranking Formula

Why don't you introduce a helper column with a pseudo-points value of 1000*gold + silver + bronze/1000, and use that to sort your table?

Hope this helps.

Pete

3. ## Re: Olympic Medal Table Ranking Formula

Try

=SUMPRODUCT(--(\$C\$2:\$C\$9*10000+\$D\$2:\$D\$9*100+\$E\$2:\$E\$9>=C2*10000+D2*100+E2))

4. ## Re: Olympic Medal Table Ranking Formula

@ Pete_UK

Oh.. thanx a lot.. Ya dat works well.. But if there's any way of doing it without using an extra column please tell me... I'm wondering a way using IF(), RANK(), SUMPRODUCT() & etc..

Anyways, thanx a lot 4 da quick help !

5. ## Re: Olympic Medal Table Ranking Formula

I used this formula for ranking, see attached

=COUNTIF(C:C,">"&C3)+COUNTIFS(C:C,C3,D:D,">"&D3)+COUNTIFS(C:C,C3,D:D,D3,E:E,">"&E3)+1

6. ## Re: Olympic Medal Table Ranking Formula

Thanx a lot.. ya dat works too... I was searching for this sort of formula.. Thanx !!

7. ## Re: Olympic Medal Table Ranking Formula

@ JChamz

Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

8. ## Re: Olympic Medal Table Ranking Formula

Thanks!
It is what I have been searching for. Can you or anyone explain the formula please?

9. ## Re: Olympic Medal Table Ranking Formula

this formula too helped me. Thanks Man.

There are currently 1 users browsing this thread. (0 members and 1 guests)