Duplicate values in Excel

How do I find instances of duplicates in an Excel spreadsheet column?

An example of when you may wish to find duplicates in Excel is to confirm that there has not been any human error when inputting data into Excel.

Step 1

• Highlight the column in Excel in which you wish to find duplicates.

Step 2

• Select the Conditional Formatting > Highlight Cells Rules > Duplicate Values menu.

Step 3

• Select the Format of the Duplicate Values.
  • Select either Duplicate or Unique
  • Select the format
• Click on the OK button.

Step 4

• The duplicate values will then be highlighted in the column as shown below.