Compare column B to A, delete occurences found in B, list occurrences on column C

[IT_Novice]

Hi everyone,

I have a master list of words on column A . I would like to compare words on column B against list A. If occurrences are found on B, I would like to delete them but also list them on column C for verification.

Thanks in advance for all your help. I've received so much help here just by reading through the forums, but I've not been able to find a solution for this one. Hope I've explained this clearly enough.

 

[IT_Novice]

Hi everyone,

I have a master list of words on column A . I would like to compare words on column B against list A. If occurrences are found on B, I would like to delete them but also list them on column C for verification.

Thanks in advance for all your help. I've received so much help here just by reading through the forums, but I've not been able to find a solution for this one. Hope I've explained this clearly enough.

Found a solution here; http://www.mrexcel.com/forum/showthread.php?t=384758&highlight=sheet+larger+master

I'm good on this. Thanks.