ranking w/ duplicates

[janeml]

If I have the following items I want to rank:

untitled.JPG

Right now, I have it where 98.95% is ranked 10th because of the 9 #1 spots ahead of it. How do I make it where 98.95% will be ranked 2nd? Here's an example of my formula in one of the cells: =IF(G99>1,1,RANK(G99,G$99:G$114,0))

Thanks,
Jane

[micope21]

Hi

Try this
=IF(G99>1,1,SUM(INDEX(($G99<$G$99:$G$114)/COUNTIF($G$99:$G$114,$G$99:$G$114),0))-3)