Percentrank does not always return a 1

Hi,
I'm sorry if this has already been answered, I found a few posts about percentrank but none had this exact problem.
I have several lists of integer values (not formulas) with many repeating numbers. I want to calculate a percentile value for each of these numbers making sure that all of the repeating numbers have the same percentile value.

I am having two problems:
As an example I have a list of integers ranging from 1 to 16 with many repeating values. When I calculate the percentiles for the various 16s some of them will return 0.98 and some of them will return 0.983, none of them will return 1. Several of my integers lists have the issue of not returning any 1s.

Any ideas?
Thank-you

Sounds like a rounding issue. Are you using a rounding function or precision as displayed?

Can you attach a workbook with an example?

The algorithm for PercentRank is a little obscure. If the number is matched, the result is equal to

=(rank(rng, value, 1) - 1) / (rows(rng) - 1)

So =(RANK(F2, F2:F1117, 1) - 1) / (ROWS(F2:F1117)-1) returns 0.980269058

which is the same value returned by

=PERCENTRANK(F$2:F$1117, F2, 15)

I have not used PercentRank before but based on the Excel Help, it's equal to # of occurances smaller/(Smaller + larger). So your largest value should always be 1 but that's not the case. I played around with it a little. Check out the table starting in T1.

I can combine W, X and Y into 1 formula in Z2 dragged down

=SUM($V$1:V1)/(SUM($V$1:V1)+SUM(V3:$V$29))

Does that help?