Multi-Criteria Extracts: AND Conditions, a Match Count and a Control Total
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- RANK.EQ, Ties and a Unique Rank with a COUNTIF Tie-BreakerFree
- A Top-5 List with LARGE + INDEX/MATCH (and Why Ties Break It) Pro
- Bottom-N with SMALL: Slow Sellers, Ties and Skipping Zeros Pro
- Extract Matching Rows: a k-th Match Helper with a Running COUNTIF Pro
- Multi-Criteria Extracts: AND Conditions, a Match Count and a Control Total Pro
- Distinct Lists: First-Occurrence Flags, a Running Count and Totals per Customer Pro
- Sorting Text with Formulas: COUNTIF "<" Ranks and a Two-Key Sort Pro
- Capstone: A Dynamic Top-N Leaderboard with a Bar Chart Pro