The Excel function: RANK.EQ
The RANK.EQ function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- Number Required. The number whose rank you want to find.
- Ref Required. An array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.
- Order Optional. 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.