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

[ssing202]

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]

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

[ssing202]

Thanks alot DILIPandey. It worked like magic. Many Many thanks to you

[dilipandey]

You are welcome...!!