How to determine rank from a list of numbers with Microsoft excel

Formula Syntax:

=RANK(number, ref , [order] )

number - This parameter indicates a specific cell which is compare with the list. ref - This parameter indicates a rang of absolute cells where numbers are exists. [order] - This parameter indicate this is optional parameter. And possible parameter value is 0 or 1. If you set 0 then the max value will be ranked 1 otherwise min value will be ranked 1 Example: See the above figure:

=RANK(B3,$B$3:$B$7,0)