[Video Tutorial] Learn Microsoft Excel - How To Find The Rank of a Number From the list Using RANK() Formula

Syntax
RANK(number,ref,[order])
The RANK function syntax has the following arguments:
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.

Note:
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.