Rank from highest to lowest

Highest score wins.
We determine who is the champion(s), 2nd, 3rd winner etc.
If two winners have the same highest score, both are 1st winner. The next will be 3rd winner.
If three winners have the same highest score, three are 1st winner. The next will be 4th winner.
The same logic applies to 2nd, 3rd winners and so on.

For example:
Score of different competitors
John || Mary || Sam || Susan || Helen
10 || 8 || 8 || 6 || 3

Champion: John
2nd winner: Mary, Sam
3rd winner: --
4th winner: Susan
5th winner: Helen

How could I write a series of formula which can rank and list the winners automatically?

Click to see the sample sheet for an overview and example.

Thanks a lot for your answer. ^_^

Check the solution..


Don't forget to click *

Originally Posted by Vikas_Gautam

Check the solution..


Don't forget to click *

Thanks a lot.

Unfortunately it is not what I want.

I would like a formula which can declare who is the champion, 2nd winner, 3rd winner etc.

Umm, 1 = Champion, 2 = 2nd winner, 3 = 3rd winner etc.

(sorry, deleted)