Question: how to create formula in excel for ranking?
Answer: Summary. ... 
Rank a number against a range of numbers.
A number that indicates rank.
=RANK (number, array, [order])
number - The number to rank. ... 
The Excel RANK function assigns a rank to a numeric value when compared to a list of other numeric values.