COMPARE 2 COLUMNS IN EXCEL AND FIND DIFFERENCES

I was working on data from two difference data sources where accounts terminated in DataSource-A have to be identified in DataSource-B. Once identified the accounts have be terminated in the DataSource-B.
In addition, I only had access to DataSource-B.
The extract from both DataSources was copied over to different excel worksheets.
To simplify the process, I copied all data to a single worksheet in different column.

• Column A - Contains the data from DataSource-A (All Accounts terminated in DataSource-A)
• Column B - Contains the data from DataSource-B (All Accounts that are active in DataSource-B)
• Column D - Result post comparison where data from Column B existed in Column A.

If you want to identify the Unique records in Column A when compared to Column B. Apply this formula in Column C: =IF((ISERROR(MATCH(A2,$B$2:$B$10,0))),A2,"")
If you want to identify the Unique records in Column B when compared to Column A. Apply this formula in Column C: =IF((ISERROR(MATCH(B2,$A$2:$A$10,0))),B2,"")

Hope this was helpful.....