PERCENTRANK
Returns the rank of a value in a data set as a percentage. Replaced by PERCENTRANK.INC.
Syntax
PERCENTRANK(array, x, [significance])
Parameters
- array: Required. The array or range of data with numeric values
- x: Required. The value for which you want to know the rank
- significance: Optional. A value that identifies the number of significant digits for the returned percentage value (default 3)
Example
=PERCENTRANK(A1:A10, 8)