Verifying and moving non matching numbers in columns

[DRKENNE]

I have two columns ,one with 1000 numbers (A) and one with 1700 (B). Column
1 is the correct column. I want to compare columns A and B and move those in
B that don't match or appear in A to a third column. End result should be
#'s in A and B should match and a third column (C) contains #'s that were in
B but didn't match A. I'm trying to confirm matches in A and B and cull out
those that don't match into C. Make any sense?

 

[Max]

Pl stay in the same thread. I've replied to you further there,
and provided a link to a working sample for your easy reference:
http://www.savefile.com/files/1571748
Extract numbers in List B not in List A.xls

 

[DRKENNE]

Thanks

Pl stay in the same thread. I've replied to you further there,
and provided a link to a working sample for your easy reference:
http://www.savefile.com/files/1571748
Extract numbers in List B not in List A.xls

 

[Max]

Welcome.