Validating Rows: Rule Checks with AND, OR and an Error Count
This lesson is part of the course
In this lesson
You check 12 orders against four business rules, count the rule breaks per row and report the error rate.
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
- Trimming Spaces & Fixing Case: TRIM, PROPER, UPPER Locked
- Splitting Codes & Names: LEFT, MID, FIND Locked
- Converting Text Numbers & Text Dates into Real Values Locked
- Standardising Categories with a Mapping Table (XLOOKUP) Locked
- Finding Duplicates & First Occurrences with COUNTIFS Locked
- Handling Blanks & Outliers: IF, MEDIAN and Flags Locked
- Validating Rows: Rule Checks with AND, OR and an Error Count Locked
- Capstone: an Analysis-Ready Table and a Region × Month Summary Locked