RANK(x,ref,order)
x: number whose rank you want to find
ref: list of numbers
order: 0 (descending order) or non-zero (ascending order); defaults to 0
In case of a tie, RANK returns the largest possible rank.
This function is Excel compatible.
PERCENTRANK, RANK.AVG.