Ranking Help

[BuzzT]

Hi Everyone,

I am trying to assign a point score based on a ranking of pecentages in two columns. In the first percentage column (column B), a point score of 1 to 6 is assigned based on the highest percentage (6 for highest, 5 for second highest, etc.). I seem to have this one solved in column C.

The problem is ranking the next percentage column (column D), which needs to assign points in reverse ranking (6 for lowest, 5 for next lowest, etc.) in Column E. Again, to some degree I have acheived this, however as you will see in the attached file, when there are duplicate values, it assigns the lower possible point score, instead of the next one in the sequence (i.e. 6, 5, 4, 2, 2, 1). What I need is for it to do 6, 5, 4, 3, 3, 2 (skipping 1 altogether).

I hope this is understandable as it appears confusing even to me and I am at a loss right now.