Uploaded September 2026 | Updated November 2026, 3 days ago
How to build a leaderboard in Excel that ranks and re-sorts itself.
β¬οΈ Download the example file here and follow along: bit.ly/leaderboard26file
π©βπ« Join my Excel Expert course: bit.ly/leaderboard26course
π¬ MORE FREE EXCEL TEMPLATES, full playlist here: 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: myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
#Excel #ExcelLeaderboard #ExcelTemplate
How to build a leaderboard in Excel that ranks and re-sorts itself.
β¬οΈ Download the example file here and follow along: bit.ly/leaderboard26file
π©βπ« Join my Excel Expert course: bit.ly/leaderboard26course
π¬ MORE FREE EXCEL TEMPLATES, full playlist here: 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: myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
#Excel #ExcelLeaderboard #ExcelTemplate
![Excel Tutorial for Beginners [Made Easy]
β¬οΈ Download the example file here and follow along: https://bit.ly/beginner24file
π©βπ« Advanced Excel Formulas course: https://bit.ly/formulas24course
π©βπ« Excel Tables course: https://bit.ly/tables24course
Excel is the key to unlocking limitless opportunities. Itβs a skill that can elevate your career, manage your finances like a pro, and turn raw data into powerful insights. In this video, weβll cover everything from the basics right through to tools most Excel users never learn, which holds them back. Weβll start with navigating the interface, entering data, including some shortcuts, as well as formulas and functions, Formatting, including Conditional Formatting, Sorting & Filtering, Data Cleaning, Tables, Charts and PivotTables, and all in well under half an hour.
π Useful Excel materials mentioned in this video:
- Excel Shortcuts for Windows & Mac: https://youtu.be/TmzEOze_HHs
- How to Store Data the Right Way: https://youtu.be/CNlw1-Vh4cE
- PivotTable Tricks That Will Change the Way You Excel: https://youtu.be/187xEPVg1Gc
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
β² TIMESTAMPS
0:00 What youre going to learn
0:47 Understanding the Excel interface
1:56 How to enter and navigate data
4:08 Every beginner needs to know this trick
4:40 How to create formulas and functions
6:20 Why & how to use $ (Dollar) sign in formulas
7:27 LIMITED OFFER
7:56 Simple & conditional formatting
10:03 How to sort & filter data
11:47 How to delete duplicates
12:21 Why you need to use Excel tables
14:34 LIMITED OFFER
14:47 Different types of charts and their purpose
17:37 One of the most useful Excel tools (PivotTables)
19:25 Slicers to filter PivotTable data
#Excel #ExcelTutorial #ExcelForBeginners Excel Tutorial for Beginners [Made Easy]](https://i.ytimg.com/vi/fzdn1vcHPsA/mqdefault.jpg)









