WorksheetFunction.Rank_Avg (Excel)

Returns the rank of a number in a list of numbers; that is, its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.

Rank_Avg (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblRank_Avg As Double
dblRank_Avg = WorksheetFunction.Rank_Avg(Arg1:=dblArg1, Arg2:=)

Arguments

Arg1 (Double) - Number - The number whose rank you want to find.

Arg2 (Range) - Ref - An array of, or a reference to, a list of numbers. Non-numeric values in reference are ignored.

Arg3 - Order - A number that specifies how to rank number. If the order is 0 (zero) or omitted, Microsoft Excel ranks the number as if the reference were a list sorted in descending order. If the order is any non-zero value, Excel ranks number as if the reference were a list sorted in ascending order