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:
- Select the column you want to find the differences.
- Use the Ctrl key to select the original column.
- On the Home tab, select Find & Replace, Go To Special, check Row Differences and click Ok.
The items in the difference column will be highlighted for you.
Then select the red font color in order for you to see the differences between the column.