percentrank that doesn't count blanks

[Berrett]

I have an array of numbers that includes blanks and zeros. The zeros are legitimate values, but the blanks are "missing", so they are different.

I want a percentrank of all of the values that are not blank. When I run just a normal percentrank function it treats all of the blanks as zero, which throws off the results.

Is there a way I can get the first argument in the percentrank function (the one that asks for the array) to ignore the blanks? If not, is there another way to go about this?

 

[Berrett]

Retract the question please: I ran some tests and apparently the blanks are not affecting the results in the way that I thought they were. Non-blank values appear to be correct even when the blanks are present.

Thanks anyway.