Build a Self-Updating Leaderboard in Excel (Free Template)
From MyOnlineTrainingHub Ā· Ā· 10 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
How to build a leaderboard in Excel that ranks and re-sorts itself. ā¬ļø Download the example file here and follow along: https://bit.ly/leaderboard26file š©āš« Join my Excel Expert course: https://bit.ly/leaderboard26course
š¬ MORE FREE EXCEL TEMPLATES, full playlist here: https://bit.ly/templates26playlist
Sorting a list largest to smallest tells you who is on top right now. Change one number and it's out of date. This leaderboard recalculates the rankings and rearranges the rows on its own, with no macros and every calculation visible on the sheet.
The example uses sales against individual targets, but the same structure works for student marks, customer service scores, project delivery or anything else you can measure. If you don't have individual targets, rank the raw results directly.
Attainment divides each person's result by their target, wrapped in IFERROR so a half-finished row shows zero instead of a #DIV/0! error. RANK.EQ turns that into a position, with the order argument set to 0 so the largest value ranks first. Equal results get equal ranks and the next rank is skipped, which is worth knowing if the leaderboard decides bonuses or prizes. PERCENTRANK then shows where each result sits across the whole group, so the top scorer reads 100% and the lowest reads 0%.
The summary at the top uses SUM for total sales and target, LARGE to pull the highest attainment, and SMALL to find the cutoff for the bottom three. Both LARGE and SMALL take a position argument, so pulling the second or third best is a one character change.
The interactive part is three data validation drop-downs for sort field, sort order and region. XMATCH converts the chosen field name into its column number. SWITCH converts Ascending and Descending into 1 and -1. SORT reorders the whole table by that column and direction, and VSTACK adds the headers back on top. The helper cells holding those numbers are hidden with white font.
SORT needs Excel 2021 or Microsoft 365. VSTACK needs Excel 2024 or Microsoft 365, so without it you can type the headers in manually and use SORT on its own.
A three colour scale on the attainment column makes performance readable at a glance. The thresholds are set to real numbers rather than lowest and highest value, so a colour means the same thing every time the data changes.
At the bottom, SUMIFS totals sales and target for the selected region and COUNTIFS counts how many reps reached 100% of target. Change the region in the drop-down and those figures update too.
After that, the only thing you maintain is the data entry table.
LEARN MORE ===========
š° EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
šÆ FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
š¬ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
#Excel #ExcelLeaderboard #ExcelTemplate