Removing column 2 entries from col 1

[john]

I have two lists of email addresses

Column one are prospects
Column two are customers

I'd like to remove all the customer email addresses in col 2 from
column 1

My desired end result is that column 1 will only contain prospect
emails and no customer emails.

I've been trying to Google this but I don't really know how to phrase
what it is I'm trying to do.

Thanks

PS I use Excel 2002 (Win XP)

 

[Dave Peterson]

Insert a new column B between column A and B.
Put this in B1:

=isnumber(match(a1,c:c,0))

Then copy it down the column for the length of column A.

Now select column B and do
Data|filter|autofilter
Show the cells with True in them.
(These are the cells in column A that appear in column C.)

Hilight those visible cells and hit the delete key to clear the contents of
those visible cells.

Delete column B
And sort column A (select column A and then data|Sort) to move all those blank
cells to the bottom of the list.

 

[john]

That worked perfectly!

Thanks so much

Insert a new column B between column A and B.
Put this in B1:

=isnumber(match(a1,c:c,0))

Then copy it down the column for the length of column A.

Now select column B and do
Data|filter|autofilter
Show the cells with True in them.
(These are the cells in column A that appear in column C.)

Hilight those visible cells and hit the delete key to clear the contents of
those visible cells.

Delete column B
And sort column A (select column A and then data|Sort) to move all those blank
cells to the bottom of the list.