Hi Geff.
The PercentRank formula of...
PERCENTRANK(array,x,significance)
where...
array is the array or range of data with numeric values that defines
relative standing.
x is the value for which you want to know the rank.

comes from...
=(MATCH(x,array)-1)/(COUNTA(array)-1)

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"geff" wrote:

what is the underlying formula for the percentrank function