Compare and Copy
 

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

Compare and Copy
 

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!A 2,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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CC" wrote:
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

Compare and Copy
 

it work perfectly

thank you

cc

"Max" wrote:

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!A 2,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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CC" wrote:
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

Compare and Copy
 

Welcome, good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CC" wrote in message
...
it work perfectly

thank you

cc