How to Find Duplicate Values in Excel

Find Duplicate Values in Excel

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

1) He in data "apple" and "orange" has duplicate values.

2) Select total data.

3) Select Conditional Formatting from the Home tab.

4) Select Highlight Cell rules a drop down menu will appear.

5) Select duplicate values option.

6) Select the required format in "Values With" option.

7) Here it is. Better to apply color filter. How to use color filter