# PERCENTRANK.EXC

Formulas / PERCENTRANK.EXC
Calculate the relative ranking of a value in a data set as a percentage.
`PERCENTRANK.EXC(array, x, [significance])`
• array - required, data set with numeric values
• x - required, value to find the rank of
• significance - [OPTIONAL]

## Examples

• `PERCENTRANK.EXC(A2:A10, 7)`

The PERCENTRANK.EXC function can be used to calculate the rank of a value in an array. For example, this returns the rank of the value 7 from the array in column A of the range A2:A10.

• `PERCENTRANK.EXC(A2:A10, 5.43)`

The PERCENTRANK.EXC function can also be used to calculate the rank of a value that is not the highest in the array. For example, this returns the rank of the value 5.43 in the same array, with 5.43 placed at the position of the highest rank.

• `PERCENTRANK.EXC(A2:A10, 5.43, 1)`

The PERCENTRANK.EXC function can also be used to calculate the rank of a value with a specific number of significant digits. For example, this returns the rank of the value 5.43 in the same array with 5 significant digits.

## Summary

The PERCENTRANK.EXC function is used to calculate the rank of a given value in a data set as a percentage of the number of values in the data set. It requires two arguments: an array and a value; if the array is empty, it will return a #NUM! error.

• The PERCENTRANK.EXC function calculates the relative rank of a value in a data set, expressed as a percentage.
• This function determines the number of values that are less than or equal to the target value.