what is the underlying formula for the percentrank function
 

what is the underlying formula for the percentrank function

what is the underlying formula for the percentrank function
 

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