Related Functions:

The PERCENTRANK.EXC function returns the relative position, between 0 and 1, exclusive, of a specified value within a supplied array.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.




Argument Description
array The array or range of data with numeric values that defines relative standing
x The value for which you want to know the rank

  x must be within the range of the values in the supplied array, but it does not need to be exactly equal to one of the values
  If x is not found in the array, the array values are interpolated to calculate the percentage rank
[significance] Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (


  A B C E
1 Data      
2 1      
3 3      
4 4      
5 7.5      
6 8      
7 8      
8 9      
9 10      
10 10      
12 Formula Result Notes
13 =PERCENTRANK.EXC(A2:A10,2) 0.15 Returns the rank of the value 2 from the array contained in A2:A10
14 =PERCENTRANK.EXC(A2:A10,5) 0.328 Returns the rank of the value 5 from the array contained in A2:A10
15 =PERCENTRANK.EXC(A2:A10,5) 0.32 Returns the rank of the value 5 from the array contained in A2:A10 to 2 digits

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if either:

  the supplied [significance] value is < 1
  the supplied array is empty
#N/A Occurs if the supplied x is smaller than the minimum, or greater than the maximum value in the supplied array