Expand Minimize

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.

Version Added: Excel 2010

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 was a list sorted in descending order. If the order is any non-zero value, Microsoft Excel ranks number as if the reference were a list sorted in ascending order.

Return Value

Double

Show:
© 2015 Microsoft