RANK

Fix Top-N Lists That Duplicate a Name When Scores Tie

LARGE + MATCH silently repeats a row and drops a real entrant the moment two scores tie — a bug that hides in plain sight on every sales leaderboard, because the total still comes out right. Here's the classic RANK+COUNTIF fix, the one-formula 365 SORTBY+TAKE alternative, and a free workbook.