Limitations of Standard Ranking: Excel’s built-in ranking functions often create gaps in rankings for duplicate values, which dense ranking resolves by making sure tied values share the same rank.