This article covers two things, how to find duplicates in an Excel spreadsheet and how to bulk remove them.

How to find duplicate values in a column

Firstly, highlight cells you wish to check for duplicates, then:

  1. Click Home

  2. Click Conditional Formatting

  3. Click Highlight Cell Rules

  4. Select Duplicate Values

How to bulk remove duplicates

  1. Click a cell in the column you want to remove duplicates from

  2. Click Data

  3. Click Remove Duplicates

  4. Select the column to check, generally you'd just choose one eg: ItemCode

  5. Click ok

  6. You will get a message saying how many were removed and how many remain.

Did this answer your question?