You can remove duplicates in Excel using the built-in Remove Duplicates feature. Here’s how :
Steps to Remove Duplicates :
-
Select the Data
- Click anywhere inside your dataset or select the range where you want to remove duplicates.
-
Open the Remove Duplicates Tool
- Go to the Data tab in the ribbon.
- Click Remove Duplicates in the Data Tools group.
-
Choose Columns to Check for Duplicates
- A pop-up window appears.
- Select the columns where you want to check for duplicate values.
- If your data has headers, make sure to check the "My data has headers" box.
-
Click OK
- Excel will remove duplicate rows and show a message with the number of duplicates removed.
Alternative: Using Conditional Formatting to Highlight Duplicates
If you want to highlight duplicates before deleting them:
- Select your data range.
- Go to Home → Conditional Formatting → Highlight Cell Rules → Duplicate Values.
- Choose a formatting style and click OK.
