Quite often, you have to compare two columns in excel to find duplicates or 'missing' rows. Though there are many ways to do this, the following MS article gives a simple solution.
https://support.microsoft.com/kb/213367?wa=wsignin1.0
https://support.microsoft.com/kb/213367?wa=wsignin1.0