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

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.

Compare data from two worksheets and display difference into 3rds
 

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","duplica te")

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

On Aug 6, 5:04*pm, auntiespyke
wrote:
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.

Compare data from two worksheets and display difference into 3
 

Hi Pete,

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



"Pete_UK" wrote:

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","duplica te")

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

On Aug 6, 5:04 pm, auntiespyke
wrote:
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.

Compare data from two worksheets and display difference into 3
 

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

Thank you much for the solution.



"auntiespyke" wrote:

Hi Pete,

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



"Pete_UK" wrote:

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","duplica te")

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

On Aug 6, 5:04 pm, auntiespyke
wrote:
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.

Compare data from two worksheets and display difference into 3
 

You're welcome - thanks for feeding back.

Pete

On Aug 6, 6:51*pm, auntiespyke
wrote:
Never mind!! *It works just perfectly. *I just had it in the wrong sheet.

Thank you much for the solution.