How to remove duplicates in Excel?

Data Science, AI and ML
,
1

Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them.

  1. Select the cells you want to check for duplicates.
  2. Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
  3. In the box next to values, pick the formatting you want to apply to the duplicate values, and then click OK.

Note: Excel can’t highlight duplicates in the Values area of a PivotTable report.