Rank and Count IF Formulas

**wayneknox01** · 10-14-2009, 06:34 AM

I have the following formula set-up:

=RANK(R2,$R$2:$R$51)+COUNTIF($R$2:R2,R2)

It basically ranks a list of percentages in a given range (R2:R51) - however for some reason it does not return #1? I have to then minus 1 off each result to get a definitive list of rankings.

Can anybody help?

Thanks.

**DonkeyOte** · 10-14-2009, 06:49 AM

you need to subtract 1 from the COUNTIF, eg

=RANK(R2,$R$2:$R$51)+COUNTIF($R$2:R2,R2)-1

ie you only want to increment the RANK for the 2nd+ instance of R value - ie where countif returns 2 increment RANK by 1 etc...