How to compare two columns and print the difference in third column

**ssing202** · 12-05-2011, 12:27 AM

Hi Everyone,

I need to compare two two columns in a excel and i want values present in column1 and not in column2.
There are alot of data that i need to sort so i can't do it manually, it will be very time consuming.Help from anyone will be highly appreciated.
EX.

column1 column2
Adam Boehm Adam Boehm
Adam S Henry Adamali A Merchant
Aditya P Ingale Adam S Henry
Adamali A Merchant

I have data in this format. I want to compare the columns and print data that is present in column1 and not in column2. column3 should have.

column3
Aditya P Ingale

Thanks in advance.

**dilipandey** · 12-05-2011, 10:32 AM

Assuming you have the data in column A and column B, use following forumula:-

=IF(ISERROR(MATCH(A4,B:B,0)),A4,"")

Above will print the data which is there in Column A but not in Column B.

Let me know if this helps.

Cheers

Thanks,
DILIPandey