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 Information
Version Added: Excel 2010
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 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