VPERCRANK function

Description

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

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

Note

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

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