# RANK

Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

**Syntax**

**RANK**(**number**,**ref**,order)

**Number** is the number whose rank you want to find.

**Ref** is an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.

Order is 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.

**Remarks**

RANK gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers, if the number 10 appears twice and has a rank of 5, then 11 would have a rank of 7 (no number would have a rank of 6).

**Examples**

If A1:A5 contain the numbers 7, 3.5, 3.5, 1, and 2, respectively, then:

`RANK(A2,A1:A5,1)`

equals 3`RANK(A1,A1:A5,1)`

equals 5