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.

1] Compare columns (Find and match different data) In many cases, you will likely have two columns in an Excel spreadsheet with data, and your task is to find out whether or not a data point in ...