Compare data from two worksheets and display difference into 3rd s

[auntiespyke]

Hi,
I'm trying to compare names in two worksheets and display unmatching names
on a third worksheet.

WS#1 compares a new list of names in column A to WS#2 which is the old list
of names in column A. I want to pull the names that are in WS#1 that are not
in WS#2 and display those new names onto WS#3 in column A.

I've tried what I can using LOOKUP and IF-AND-OR, but apparently don't know
what I'm doing since it won't work.

Thanks for your help.

 

[Pete_UK]

Assuming you have a header row and your data starts on row 2 in both
sheets, then in a helper cell in Sheet1 (cell B2 ?) you can put this
formula:

=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"Unique","duplicate")

and copy this down to cover all the names in Sheet1. Then apply
autofilter to the helper column, and select Unique from the filter
pull-down. Now highlight all the visible data in Sheet1, including
headers, and click <copy> then paste into Sheet3. Then you can remove
the helper column from Sheet1.

Hope this helps.

Pete

 

[auntiespyke]

Hi Pete,

I'm getting an error - it's not accepting 0 for the match_type in the formula.

 

[auntiespyke]

Never mind!! It works just perfectly. I just had it in the wrong sheet.

Thank you much for the solution.

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete