excel find duplicate values in two lists

EXCEL FIND DUPLICATE VALUES IN TWO LISTS HOW TO

Go to ‘ Home’ ‘ Conditional Formatting‘.

Select the range with duplicate values (i.e.

This can be accomplished by following the next steps: However, sometimes we want to highlight the second occurrence or later occurrences of the duplicate values.

If you use the steps shown above, you’ll be able to highlight ALL the occurrences of the values with duplicates.

EXCEL FIND DUPLICATE VALUES IN TWO LISTS HOW TO

You will see that duplicate values are highlighted as shown below:įigure 4: Highlighted duplicate values How to highlight cell rules after second occurrence

You will see a window as shown below, Click “ OK“.

Click on ‘ Conditional Formatting‘ ‘ Highlight Cells Rules‘ ‘ Duplicate Values‘.įigure 2: Steps to highlight duplicate values.

Now if we have the duplicate values in a column or columns (as we have in columns A and B in figure2 below), the following steps can be carried out to highlight the duplicate values.

The ‘Conditional Formatting’ menu option can be found on the Home tab of Excel 2013 as shown below. You can do it with just a few clicks through the ‘Conditional Formatting’ menu option. Highlight the first occurrence of each valueįinding duplicates in existing data is one of the important features of MS Excel.Highlight duplicate values starting at the second occurrence of each value.In this post I’ll cover all you need to know to deal with duplicate/unique values in MS Excel.Īfter reading this post you’ll be able to: If you have worked with MS Excel for a while I bet you have had the need to highlight/count unique or duplicate values.

Excel find duplicate values in two lists