To pinpoint duplicate entries, apply Excel's conditional formatting feature: Open the Excel worksheet containing the data in question. Select the column or range you want to inspect for duplicates.

When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.