PERCENTRANK function
Summary
Returns the percentage rank of a value in a data set
Syntax
PERCENTRANK(array,x,[significance])
The PERCENTRANK function syntax has the following arguments:
• Array Required. The range of data (or pre-defined array) of numeric values within which percent rank is determined.
• X Required. The value for which you want to know the rank within the array.
• Significance Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK uses three digits (0.xxx).
• Array Required. The range of data (or pre-defined array) of numeric values within which percent rank is determined.
• X Required. The value for which you want to know the rank within the array.
• Significance Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK uses three digits (0.xxx).
Example
=PERCENTRANK(A2:A11,2)
=PERCENTRANK(A2:A11,4)
=PERCENTRANK(A2:A11,8)
=PERCENTRANK(A2:A11,5)
=PERCENTRANK(A2:A11,4)
=PERCENTRANK(A2:A11,8)
=PERCENTRANK(A2:A11,5)