Find Duplicates

 There are 8 steps in this article section

This section teaches you how to find duplicates (or triplicates) in Excel.

Step 1: Select the range of your Excel sheet, in this example we will be using the range of A1:C10.

Step 2: On the "Home tab", Click "Conditional Formatting, Highlight Cells Rules, Duplicate Values"

Step 3: "Select" a formatting style and Click "OK".

Result: Excel highlights the duplicate names in red for you.

Note: Select "Unique" from the first drop-down list to highlight the unique names.

As you can see, Excel highlights duplicates (Juliet, Delta), triplicates (Sierra), quadruplicates (if we have any), etc.

Remove Duplicates

Step 1: Click any single cell inside the data set.

Step 2: Click on the "Data tab", Click "Remove Duplicates"

Step 3: Leave all check boxes checked and Click "OK".

Result: Excel removes all identical rows (blue) except for the first identical row found (yellow).

To remove rows with the same values in certain columns, execute the following steps.

Step 4: For example, remove rows with the same Last Name and Country.

Step 5: Check "Last Name" and "Country" and click "OK".

Result: Excel removes all rows with the same Last Name and Country (blue) except for the first instances found (yellow).

Original article taken from