Need formula help please....

C

cashbagg

I have a worksheet. Column A contains a list of emails. Column
contains a list of emails to be eliminated from Column A. I need
formula that can do this.

Thanks
 
T

Tom Ogilvy

formulas don't eliminate values in other cells. You can mark which
addresses you want to delete using a formula

Insert a New column B and in B2 put in a formula like

=if(Countif(C:C,A2)>0,"Delete","Keep")

Then drag fill down the column

Select columns A and B and do Data=>Filter=>Autofilter and select Delete
from the dropdown in Column B.

Select A2:B lastrow and then do Delete and shift up.

Now do Data=>Filter=>Autofilter to remove the filter and delete column B.
 
C

CLR

In C1 put this formula and copy down as far as you have data in column
A..........then column C will only contain values that are in column A but
are not in column B. You can then do Copy . PasteSpecial > Values to delete
the formulas and be left with only the values.

=IF(VLOOKUP(A1,B:B,1)=A1,"",A1)

Vaya con Dios,
Chuck, CABGx3
 
Top