Module 5 · You are here
Stripping Formatting and Deduplicating
Remove the visual sludge inherited from five previous spreadsheets, then find the workers who appear twice under slightly different names.
By the end of Module 5, you will be able to:
- Use Paste Values to strip conditional formatting and color coding.
- Use =UNIQUE() to extract a clean list of distinct workers.
- Use =COUNTIF(A:A, A2) to flag exact duplicates.
- Use a normalized helper column for fuzzy duplicate detection.
- Decide which of two near-duplicate rows is the source of truth.
Subsections in Module 5
5.1
Why visual formatting is a trap
Open 5.2Paste Values and helper columns
Open 5.3UNIQUE and COUNTIF for exact duplicates
Open 5.4Fuzzy duplicate detection
Open 5.5Source-of-truth checkpoint
OpenStart here: Module 5.1 · Why visual formatting is a trap
Begin Module 5
After Module 5: Module 6 · Producing the Campaign Roster Health Report
Next: Module 6 · Producing the Campaign Roster Health Report