Verifying and moving non matching numbers in columns
 

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?

Verifying and moving non matching numbers in columns
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DRKENNE" wrote:
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?

Verifying and moving non matching numbers in columns
 

Thanks

"Max" wrote:

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DRKENNE" wrote:
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?

Verifying and moving non matching numbers in columns
 

Welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DRKENNE" wrote in message
...
Thanks