Bottom-N with SMALL: Slow Sellers, Ties and Skipping Zeros
This lesson is part of the course
In this lesson
You list Fernhill's five slowest-selling products with SMALL, build an ascending unique rank for the names and skip the new products that have not sold yet.
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