How to use the RANK Function in Excel
We must know about the order of rank by this video
=RANK(number,ref,[order])
=RANK(number,ref) ; Rank will be in descending order though 0 is omitted.
=RANK(number,ref,0) ; 0 is used for descending order
=RANK(number,ref,1) ; 1 is used for ascending order