Show menu

VPERCRANK function


VPERCRANK(value,variable[,filter]) returns the percentile rank of a value.

In the absence of ties in the data, this function is the inverse of the VPERCENTILE function.


This function calculates a statistic on a variable. Be careful when you use this function in cells of the columns that correspond to the variable, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cell to avoid this.

Related functions

Share on Facebook Share on Twitter

This site uses cookies to store information on your computer. More info...