PERCENTRANK.EXC
Returns the rank of a value in a data set as a percentage (0..1, exclusive)
Syntax
PERCENTRANK.EXC(array, x, [significance])
Parameters
- array: Required. The array or range of data
- x: Required. The value for which you want to know the rank
- significance: Optional. The number of significant digits (default 3)
Example
=PERCENTRANK.EXC(A1:A10, 8)