Excel 2007 : Compare: Sheet1 - Sheet2 into Sheet3

**vbjohn** · 07-17-2009, 02:46 PM

How can I compare: Sheet1 Column A to Sheet2 Column A and put the ones that do not match in Sheet3 Column A?

I am tring to weed out the duplicate values.

**NBVC** · 07-17-2009, 02:51 PM

in Sheet1, you can use formula =Isnumber(Match(A1,Sheet2!A:A,0)) this returns True and Falses based on if match found...

you can do same from Sheet2 to Sheet1...

Then filter the data for FALSE on each sheet.. through Data|Filter|Autofilter and copy paste to Sheet3, column A

**vbjohn** · 07-17-2009, 03:22 PM

Your great. Thanks.

**NBVC** · 07-17-2009, 03:33 PM

Please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save