How to Remove Duplicates in Excel

Method 1: Using the Remove Duplicates Tool

1. Select the dataset (including column headers).
2. Go to the Data tab.
3. Click on Remove Duplicates in the “Data Tools” group.
4. In the popup window, select the columns where you want to remove duplicates.
5. Click OK, and Excel will remove the duplicate rows.

Method 2: Using Advanced Filter

1. Select your data range.
2. Go to the Data tab and click Advanced in the “Sort & Filter” group.
3. Choose Copy to another location (if you want to keep the original data).
4. Check the Unique records only box.
5. Select a location to copy the unique data and click OK.

Method 3: Using Excel Formulas

Use the Remove Duplicates feature for quick removal. However, if you want to highlight duplicates first:

• Use the formula:excelCopyEdit=COUNTIF(A:A, A2) > 1 This formula checks if a value appears more than once in column A.
• Apply Conditional Formatting to highlight duplicates before removal.