Rankings of % - %'s over 100 same Score of 1

[Hudson]

Please see attached - I am trying to create a ranking formula with all percentages at 100 or above at a Rank of '1' and then the rest of the scores fall into place after that, but am having trouble. Any help is appreciated

[daddylonglegs]

...so if you have 6 values @ 100% or above they are all ranked 1? What rank is given to the next % - 7? If so then try this formula in B2 copied down

=IF(A2>=1,1,RANK(A2,$A$2:$A$37))

or if first rank < 100% should be 2 try this one

=IF(A2>=1,1,COUNTIFS($A$2:$A$37,">"&A2,$A$2:$A$37,"<1")+2)

[Hudson]

Can you apply the formula in my file and re-upload for me - I can't get it to work?

[daddylonglegs]

OK, I made 2 different suggestions, take your pick......

[Hudson]

In column B - your Rank 1 selection, how come the worst score (0) does not have a Rank of 36 - there are 36 data points?

[Hudson]

Nevermind - there are 2 0's (35 is on their twice) - Thanks for the help