Name
PERCENTRANK
Synopsis
Use PERCENTRANK to determine the rank of a specific number within a numeric list. The rank of the number is basically it position in the list if you were to sort the list in ascending order.
To Calculate
=PERCENTRANK(Number,Ref,Significance)
The Number and
Ref arguments are required for this
function. The Significance argument is
optional.
-
Number Indicates the number whose rank you want to find.
-
Ref Indicates a list of numeric values. Any non-numeric values are ignored by PERCENTRANK.
-
Significance Indicates the number of digits that the percentage value should be rounded to. If the value is omitted the default rounds the number to three digits.
Example
Figure 15-35 illustrates how PERCENTRANK is used to determine the rank of the number 45 within the array of values.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
