Question: what is the formula of rank in excel?
Answer: =RANK(B2,$B$2:$B$11) For ascending order, type a 1, or any other number except zero. If you were comparing golf scores, you could type a 1, to rank in ascending order.