How to find duplicates data in Excel

To find duplicates in Excel. Go here to remove duplicates.

1. Select the range A1:C10.

     

2. On the Home tab, click Conditional Formatting, Highlight Cells Rules, Duplicate Values...

     

3. Select a formatting style and click OK.

    

Result. Excel highlights the duplicate names.

   

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. Execute the following steps to highlight triplicates only.

4. First, clear the previous conditional formatting rule.

5. Select the range A1:C10.

6. On the Home tab, click Conditional Formatting, New Rule...

    

7. Select "Use a formula to determine which cells to format".

8. Enter the formula =COUNTIF($A$1:$C$10,A1)=3

9. Select a formatting style and click OK.