WorksheetFunction.PercentRank_Exc method (Excel)
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
Syntax
expression.PercentRank_Exc (Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Array - The array or range of data with numeric values that defines relative standing. |
| Arg2 | Required | Double | X - The value for which you want to know the rank. |
| Arg3 | Optional | Variant | Significance - A value that identifies the number of significant digits for the returned percentage value. If omitted, PercentRank_Exc uses three digits (0.xxx). |
Return value
Double
Remarks
If array is empty, PercentRank_Exc returns the #NUM! error value.
If significance < 1, PercentRank_Exc returns the #NUM! error value.
If x does not match one of the values in array, PercentRank_Exc interpolates to return the correct percentage rank.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.