Use:- Computes the rank of a number within a given set of data
- Syntax:
- RANK( value , range , order
)
Order = zero for descending ranks (i.e., highest=1, second highest=2, ...)
Order = one for ascending ranks
- Examples:
- Cell D3 formula: RANK( C3 , C3:C8 , 0 )
Cell D4 formula: RANK( C4 , C3:C8 , 0 ) 
-
