Manually re-sorting your Excel tables every time a score changes is a waste of time. The RANK.EQ function automates leaderboards by assigning positions instantly. Whether you're tracking sales or race ...

Microsoft isn't trying to confuse you—Excel's three ranking functions balance flexibility, compatibility, and tie handling.