Resources > Formula Help

How Do I Remove Duplicates in Excel?

Last Updated: June 2026

Quick Answer

To remove duplicates in Excel, select your data, go to Data > Remove Duplicates, choose the columns to check, and click OK.

Method 1: Use Remove Duplicates

1. Select your data range.
2. Go to the Data tab.
3. Click Remove Duplicates.
4. Choose the columns Excel should check.
5. Click OK.

Method 2: Use UNIQUE

=UNIQUE(A2:A100)

This returns a clean list of unique values without deleting your original data.

When to Use Each Method

• Use Remove Duplicates when you want to permanently clean a dataset.
• Use UNIQUE when you want a dynamic list that updates automatically.

Need Help Cleaning Excel Data?

If your spreadsheet has duplicate records, messy imports, or inconsistent data, I can help clean it up.

Book Excel Help