PERCENTRANK
Returns the percentage rank of a value in a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Returns the rank of a value in a data set as a percentage (Legacy).
Syntax
PERCENTRANK(array, x, [significance])
Arguments
array(range) — Data set.x(number) — Value.significance(number) — Significant digits.
Examples
Legacy Percent Rank
Rank of 5 in range.
FORMULA
=PERCENTRANK(A1:A5, 5)
RESULT
0.8
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 3 |
| 4 | 5 |
| 5 | 7 |
| 6 | 9 |