RANK.AVG function
Returns the rank of a number in a list of numbers
Syntax
RANK.AVG(number, ref, [order])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| number | Yes | The number whose rank you want to find.A3 |
| ref | Yes | A reference to a list of numbers. Nonnumeric values in ref are ignored.A2:A6 |
| order | No | A number specifying how to rank number. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.1 |
Try RANK.AVG
Average tied ranks
=RANK.AVG(5,{5;5;3},0)The two fives occupy descending positions one and two. Each receives their average, 1.5.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
RANK.AVG · top-level call
=RANK.AVG(5,{5;5;3},0)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.