The Exception Report: A Numbered List of Every Open Item
This lesson is part of the course
In this lesson
You mark every unmatched line in a helper column, pull the exceptions into a numbered report with SMALL and INDEX/MATCH, and show the difference that each open item contributes.
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 Locked
- Composite Keys: Customer & Invoice, Stripped Prefixes and False Matches Locked
- Duplicates Inside a List: COUNTIF, First Occurrences and Inflated Totals Locked
- Changed Values: XLOOKUP the Other List and Flag Each Field Locked
- Tolerance Matching: Amounts Within a Few Cents and Dates Within N Days Locked
- Partial Keys: Matching on the First Characters and Finding Numbers Inside Text Locked
- The Reconciliation Summary: Totals A vs B, Explained and Unexplained Differences Locked
- The Exception Report: A Numbered List of Every Open Item Locked