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.