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.


Frequently Asked Questions

What is the PERCENTRANK.EXC function?
The PERCENTRANK.EXC function returns the rank of a value in a data set as a percentage of all the values in the data set.
What happens if the array argument is empty?
The PERCENTRANK.EXC function returns a #NUM! error if the array argument is empty.
Does the PERCENTRANK.EXC function interpolate if the x argument does not match the values in the array?
Yes, the PERCENTRANK.EXC function interpolates to return the correct percentage rank if the x argument does not match the values in the array.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.