Exact Duplicates: COUNTIFS Keys, Survivors & UNIQUE
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Profiling the Vendor Extract: Filled Fields, Record Scores & Field CompletenessFree
- Normalising Names & Addresses: TRIM, UPPER, SUBSTITUTE & Country MappingFree
- Exact Duplicates: COUNTIFS Keys, Survivors & UNIQUE Pro
- Fuzzy Duplicates: Match Keys without Punctuation & Legal Forms Pro
- Units of Measure: Standard Codes, Conversion Factors & Price per Base Unit Pro
- Validation Rules: IBAN Length, VAT Patterns, Allowed Terms & Required Fields Pro
- Merge Rules: Building the Golden Record from Duplicate Sources Pro
- Capstone: Migration Readiness Scorecard with Traffic Lights Pro