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
Guys please help me..
Bookmarks