EXCEL: Comparing Two Columns


MOS Expert

Did you know that you can use the Go To Special command to help you compare two columns? This command identifies the differences quickly.  Here are the steps:

  1. Select the column you want to find the differences.
  2. Use the Ctrl key to select the original column.
  3. On the Home tab, select Find & Replace, Go To Special, check Row Differences and click Ok.

Compare two columns 1

The items in the difference column will be highlighted for you.

compare two columns 2

Then select the red font color in order for you to see the differences between the column.

compare two columns 3

View original post