Ranking ties

[itsjenn]

I need help putting together a formula to rank ties.

For instance, my data is as follows:
(A) (B) (C)
1 Name Score Rank
2 Jim 9 8
3 Roy 7 4
4 Bob 7 4
5 Amy 3 1
6 Lou 6 3
7 Jon 5 2
8 Ann 8 7
9 Jay 7 4

The formula in cell C2 is =RANK(B2,$B$2:$B$9,1) and is the same through C9. I don't like how the ranks skips from 4 to 7 (due to RANK formula not being able to handle ties). In my case ties are OK.

This is how I want to output to be:

(A) (B) (C)
1 Name Score Rank
2 Jim 9 6
3 Roy 7 4
4 Bob 7 4
5 Amy 3 1
6 Lou 6 3
7 Jon 5 2
8 Ann 8 5
9 Jay 7 4

Can you help? Thanks so much!

[DonkeyOte]

One possibility

Please Login or Register  to view this content.