Capstone: A Dynamic Top-N Leaderboard with a Bar Chart
This lesson is part of the course
In this lesson
You build the sales-challenge leaderboard: a unique rank on the total points, a Top-N list whose length is set in one cell, the names from the rank, and a bar chart of the top five.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- RANK.EQ, Ties and a Unique Rank with a COUNTIF Tie-Breaker Locked
- A Top-5 List with LARGE + INDEX/MATCH (and Why Ties Break It) Locked
- Bottom-N with SMALL: Slow Sellers, Ties and Skipping Zeros Locked
- Extract Matching Rows: a k-th Match Helper with a Running COUNTIF Locked
- Multi-Criteria Extracts: AND Conditions, a Match Count and a Control Total Locked
- Distinct Lists: First-Occurrence Flags, a Running Count and Totals per Customer Locked
- Sorting Text with Formulas: COUNTIF "<" Ranks and a Two-Key Sort Locked
- Capstone: A Dynamic Top-N Leaderboard with a Bar Chart Locked