WorksheetFunction.Rank_Avg method (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.

Syntax

expression.Rank_Avg (Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data type Description
Arg1 Required Double Number - The number whose rank you want to find.
Arg2 Required Range Ref - An array of, or a reference to, a list of numbers. Non-numeric values in reference are ignored.
Arg3 Optional Variant 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.

Return value

Double

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.