Excel
· 7 min read
Excel 365: 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. Here's the classic RANK+COUNTIF fix and the one-formula 365 SORTBY+TAKE alternative, plus a free workbook.
Read article