Use the RANK Function. Click on the cell where you want the ranking to appear. Enter the formula =RANK(number, ref, [order]). Replace number with the cell reference of the value you want to rank.