Using Excels Rank functions
Excels Rank functions have evolved over time, and give you the ability to ranks values in a list or column based on their value compared to other values in the same list or column. In Excel 2007 and previous versions, the function you would use to rank value is Rank and the syntax is: =RANK(Number, […]