Finding duplicates in columns

Hello Rachel,

Thank you for your post. I have attached an Excel file which gives you two solutions for finding duplicates.

The red cells are a result of the Conditional Formatting function (in the Home ribbon). You select the relevant data, click Conditional Formatting - Highlight Cell Rules - Duplicate Values.

In cell C1 there is a more complex function which compares the two columns and flags up the values in the second column which have duplicates in the first.

I kept the data simple so that it is easier to make sense of the formula. Have a look at the cell references in the Vlookup part. The Iferror part simply prevents error messages to appear in the rest of the cells.

Both methods work on both numbers and text.

I hope this helps.

Kind regards
Marius Barnard
Trainer
Best STL