What it does
Remove Duplicates helps clean repeated rows or repeated key values.
Syntax or pattern
Workflow steps vary by workbook✅
5 practical examples
1
Remove duplicate emails
Select the email column and remove duplicates.
Data → Remove DuplicatesMake a backup before removing rows.
2
Find duplicates first
Use conditional formatting before deleting.
Conditional Formatting → Duplicate ValuesPreview duplicates before removing them.
3
Remove duplicate rows
Select all relevant columns.
Data → Remove Duplicates → Select columnsThe selected columns define what duplicate means.
4
Create a unique list
Use UNIQUE instead of deleting rows.
=UNIQUE(A2:A100)Keeps the original data intact.
5
Count duplicate IDs
Use COUNTIF to flag repeats.
=COUNTIF($A:$A,A2)>1Great for audit checks.
Common mistakes to avoid
- Keep raw data separate from reports.
- Use clear table names and labels.
- Avoid over-formatting before the data structure is stable.
Related Excel examples
FAQ
Can this be combined with formulas?
Yes. Most Excel workflows work best when formulas, tables and formatting support each other.