In Excel 2010, they have renamed this function to RANK.EQ() and Microsoft recommends that you begin using it but RANK() still works.
The sytax for both RANK and RANK.EQ are:
- Number is the cell or number whose rank you want to find
- Ref is the array (list of numbers)
- Order is optional. The default is 0 and that means descending order