Compare and Copy

C

CC

I have two sheets of data OLD_LIST and NEW_LIST and I need compare
columm A2:A1000 of the OLD with columm A2:A1000 of the NEW and copy all
the ROW of the NEW_LIST that not exist in NEW_LIST to another sheet

it's possible ?
regards and thank you
 
M

Max

Assume source data in sheets named: Old_List & New_List, from row 2 down
Assume data is in cols A to D in New_List

In the 3rd sheet,

In A2
=IF(New_List!A2="","",IF(ISNUMBER(MATCH(New_List!A2,Old_List!A:A,0)),"",ROW()))
Leave A1 empty

In B2:
=IF(ROWS($1:1)>COUNT($A:$A),"",INDEX(New_List!A:A,SMALL($A:$A,ROWS($1:1))))
Copy B2 to E2. Select A2:E2, copy down to cover the max expected extent of
data in New_List's col A, say down to E200?. Minimze/hide col A. Cols B to E
will return the required results, all neatly bunched at the top.
 
C

CC

it work perfectly

thank you

cc

Max said:
Assume source data in sheets named: Old_List & New_List, from row 2 down
Assume data is in cols A to D in New_List

In the 3rd sheet,

In A2:
=IF(New_List!A2="","",IF(ISNUMBER(MATCH(New_List!A2,Old_List!A:A,0)),"",ROW()))
Leave A1 empty

In B2:
=IF(ROWS($1:1)>COUNT($A:$A),"",INDEX(New_List!A:A,SMALL($A:$A,ROWS($1:1))))
Copy B2 to E2. Select A2:E2, copy down to cover the max expected extent of
data in New_List's col A, say down to E200?. Minimze/hide col A. Cols B to E
will return the required results, all neatly bunched at the top.
Click to expand...
 
Top