Extract Matching Rows: a k-th Match Helper with a Running COUNTIF
This lesson is part of the course
In this lesson
You build a formula "filter" for one region: a helper column numbers the matching orders 1, 2, 3 …, INDEX/MATCH pulls them into a report block, IFERROR keeps the empty rows blank and a formula rule highlights the matching rows in the source.
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