The Exception Report: A Numbered List of Every Open Item
This lesson is part of the course
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
- Match or Missing: COUNTIF in Both Directions & Status Flags Pro
- Composite Keys: Customer & Invoice, Stripped Prefixes and False Matches Pro
- Duplicates Inside a List: COUNTIF, First Occurrences and Inflated Totals Pro
- Changed Values: XLOOKUP the Other List and Flag Each Field Pro
- Tolerance Matching: Amounts Within a Few Cents and Dates Within N Days Pro
- Partial Keys: Matching on the First Characters and Finding Numbers Inside Text Pro
- The Reconciliation Summary: Totals A vs B, Explained and Unexplained Differences Pro
- The Exception Report: A Numbered List of Every Open Item Pro