PERCENTRANK.EXC
Formulas / PERCENTRANK.EXCCalculate 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.
Need help with Formulas?
Frequently Asked Questions
What is the PERCENTRANK.EXC function?
What happens if the array argument is empty?
Does the PERCENTRANK.EXC function interpolate if the x argument does not match the values in the array?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.