In this tutorial we shall be learning how to rank data in Excel using rank or rank.eq functions. The RANK function and the RANK.EQ function make it easy to identify any number of scores even as a beginner. You can score the highest score on a test, or best-selling product, or populist country and also get the lowest from the ranking function in excel. Watch the video to the end to see what happens when this is a tie in a score.