Find Duplicates data In Excel

This example teaches you how to find duplicates (or triplicates) in Excel. Go here to remove duplicates.

  • Select the range of cells you wish to test. One way to do so is to click on a single cell and then press Ctrl-A.
  • On Excel’s Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values.
  • Click OK within the Duplicate Values dialog box to identify the duplicate values.
  • Duplicate values in the list will now be identified.

 


 

 

 

 

1. Select the range A1:C10.

 

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

 

3. Click Highlight Cells Rules, Duplicate Values.

Click Highlight Cells Rules, Duplicate Values

4. Select a formatting style and click OK.

Select a Formatting Style

Result. Excel highlights the duplicate names.

Duplicates

5. First, clear the previous conditional formatting rule.

6. Select the range A1:C10.

7. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

8. Click New Rule.

New Rule

9. Select ‘Use a formula to determine which cells to format’.

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

11. Select a formatting style and click OK.

New Formatting Rule

Result. Excel highlights the triplicate names.

Triplicates

 

 

 

 

Share This Post

Leave a Reply

Your email address will not be published.