Finding Duplicates & First Occurrences with COUNTIFS
This lesson is part of the course
In this lesson
You find order lines that were exported twice, keep the first copy of each and calculate the true revenue.
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