Duplicates Inside a List: COUNTIF, First Occurrences and Inflated Totals
This lesson is part of the course
In this lesson
You find invoices that appear more than once in a payments export, mark first occurrences and repeats with an expanding range, and work out the distinct invoice count and the total with each invoice counted once.
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