How to compare two columns in Excel to find duplicates

Many a times we require to compare two columns data and find out all the Duplicates. So in this article you are going to see how we can compare two columns in Excel and find out duplicates. There are two ways of comparing two columns in an Excel Worksheet. 1.By Using Excel Formula 2. By Using Excel Macro Compare two [...]