Ranking a medal tally

[ajitexcel]

Hello
I have a medal tally with the following table

Gold	Silver	Bronze	Total	Rank (Desired Result)
1		1	2	3
2	1		3	1
	2		2	4
1	2	2	5	2
		6	6	5
		6	6	5

- The criteria for ranking is
- First anyone with a max number of Gold or anyone with Gold is ranked first
- Then Silver is considered
- then bronze and finally the total number of medals if the previous three are same, or
I am not able to figure out the formula to have multiple conditions to rank.

Thanks

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)