Thursday, March 8, 2012

yogi_Compare 2 Columns Of Names And Remove Names Listed In Column 2 From Column 1

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #462

user Stoked Charlie said:
Compare 2 columns of names and remove names listed in column 2 from column 1
I have a mailing list of e-mail addresses (column A) and another list of e-mail addresses (Column D) that need to be removed from the mailing list.
How can I have google docs, compare the lists and delete the matches?
If it is not possible to delete the matches, can google output a list of matches into another column, in order for me to delete them from the mailing list.
Any and all help is appreciated.
following is a solution to the problem