RANK.EQ, Ties and a Unique Rank with a COUNTIF Tie-Breaker
This lesson is part of the course
In this lesson
You rank Fernhill Outdoor's twelve sales reps by Q3 sales, see what RANK.EQ does with ties, turn the rank into a unique 1–12 rank with a running COUNTIF and break ties by a second criterion.
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