WorksheetFunction.PercentRank_Exc (Excel)

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

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.

PercentRank_Exc (Arg1, Arg2, Arg3)


Dim dblArg2 As Double: dblArg2 = 
Dim dblPercentRank_Exc As Double
dblPercentRank_Exc = WorksheetFunction.PercentRank_Exc(Arg1:=, Arg2:=dblArg2)

Arguments

Arg1, Arg2, Arg3

Arg1 - Array - The array or range of data with numeric values that defines relative standing

Arg2 (Double) - X - The value for which you want to know the rank.

Arg3 - Significance - A value that identifies the number of significant digits for the returned percentage value. If omitted, PercentRank_Exc uses three digits (0.xxx)