List Rules: Allowed Values with COUNTIF & MATCH
This lesson is part of the course
In this lesson
You check every order's region and payment terms against the allowed lists, the way a drop-down list rule does, and count the bad and the clean orders.
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
- Number & Date Rules as Check Formulas Locked
- List Rules: Allowed Values with COUNTIF & MATCH Locked
- Dependent Lists: Category → Item with INDEX/MATCH Locked
- Text Length & Pattern Checks: LEN, LEFT, SEARCH Locked
- Duplicate Prevention: COUNTIF & COUNTIFS Rules Locked
- Cross-Field Rules: End ≥ Start and Shares = 100% Locked
- Input Form with Error Messages & an Error Summary Locked
- Template Protection Checklist & Completeness Dashboard Locked