PERCENTRANK.EXC

PERCENTRANK.EXC(array, x [,significance])

Returns the percentage rank of a value in an array of numbers (exclusive).

arrayThe array of values.
xThe value for which you want to know the rank.
significance(Optional) The number of significant digits for the returned percentage value.

REMARKS
* If "array" is empty, then #NUM! is returned.
* If "significance" < 1, then #NUM! is returned.
* If "significance" is left blank", then 3 is used (i.e. 0.xxx%).
* If "x" does not match one of the values in array, the functions interpolates to return the correct percentage rank.
* You can use the PERCENTILE.EXC function to return the number corresponding to a particular percentage from an array of numbers (exclusive).
* You can use the PERCENTILE.INC function to return the number corresponding to a particular percentage from an array of numbers (inclusive).
* You can use the PERCENTRANK.INC function to return the percentage rank of a value in an array of numbers (inclusive).
* This function was added in Excel 2010
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},1) = 0.090
2=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},1.5) = 0
3=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},2) = 0.181
4=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},3) = 0.272
5=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},4) = 0.363
6=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},9) = 0.818
7=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},10) = 0.909
8=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},15) = #N/A
9=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},"some text") = #VALUE!


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top