Compare and Copy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CC - 29 May 2008 14:43 GMT

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

Reply to this Message

Max - 29 May 2008 15:09 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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

Reply to this Message

CC - 29 May 2008 16:00 GMT

it work perfectly

thank you

cc

> 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
[quoted text clipped - 16 lines]
> > it's possible ?
> > regards and thank you

Reply to this Message

Max - 29 May 2008 21:36 GMT

Welcome, good to hear that.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> it work perfectly
>
> thank you
>
> cc

Reply to this Message