6 Ways to HANDLE Duplicates in Excel (Fast!)

Discover 6 practical ways to handle duplicates in Microsoft Excel — from quick visual identification to formulas and PivotTables. In this video, we'll look at different approaches depending on what you actually want to do with duplicate data: highlight it, remove it, identify it, count it, create a unique list, or analyze it. You'll learn: • How to highlight duplicate values with Conditional Formatting • How to permanently remove duplicates using Remove Duplicates • How to identify duplicates using Sort + Formula • How to count duplicate occurrences using COUNTIF • How to create a unique list using the UNIQUE function • How to analyze duplicates using a PivotTable Whether you're cleaning a customer list, preparing data for analysis, or simply trying to find repeated values, these techniques will give you several options to choose from. 👍 If you find this useful, consider subscribing to Excel in Excel for more practical Excel tips, tricks and tutorials. ⏱️ Chapters 00:00 Introduction 00:35 Method 1 — Conditional Formatting 01:10 Method 2 — Remove Duplicates 02:25 Method 3 — Sort + Formula 03:50 Method 4 — COUNTIF 05:35 Method 5 — UNIQUE Function 06:25 Method 6 — PivotTable 08:15 Final Thoughts