WorksheetFunction.Rank_Avg(Double, Range, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.
public double Rank_Avg (double Arg1, Microsoft.Office.Interop.Excel.Range Arg2, object Arg3);Public Function Rank_Avg (Arg1 As Double, Arg2 As Range, Optional Arg3 As Object) As DoubleParameters
- 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
- Object
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.