Identify duplicate values in Excel

For example, I have a range of Part Nos. or Book ISBNs, or Product Codes that are similar looking and difficult to compare manually. I want to easily identify the duplicates in the range.

To do it in Excel, here is the answer:

a) Select the range containing the data set. Click on "Conditional Formatting" under "Home" tab.

excel identify duplicate values

b) Click on "Highlight Cells Rules" -> "Duplicate Values".

excel identify duplicate values

c) The duplicate values in the range are highlighted as shown below.

excel identify duplicate values


You can find similar Excel Questions and Answer hereunder

1) Is there a way to get a log value of a number using Excel?

2) How can I prevent users from entering duplicate values in a range?

3) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

4) How can I find the slab in which a given value fits?

5) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

6) How can I add and link a Chart Title to a cell value?

7) How can I identify cells with Circular Reference in a WorkSheet?

8) How do I find the median salary of employees with the same skillset in my Organization?

9) How can I filter a table to get all records that have less than a particular value in a specific column?

10) Vlookup to return max value from multiple hits in Excel


Here the previous and next chapter