Need formula help please....
 

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

Thanks.


--
cashbagg
------------------------------------------------------------------------
cashbagg's Profile: http://www.excelforum.com/member.php...o&userid=27718
View this thread: http://www.excelforum.com/showthread...hreadid=472331

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.

--
Regards,
Tom Ogilvy


"cashbagg" wrote in
message ...

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

Thanks.


--
cashbagg
------------------------------------------------------------------------
cashbagg's Profile:
http://www.excelforum.com/member.php...o&userid=27718
View this thread: http://www.excelforum.com/showthread...hreadid=472331

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



"cashbagg" wrote in
message ...

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

Thanks.


--
cashbagg
------------------------------------------------------------------------
cashbagg's Profile:
http://www.excelforum.com/member.php...o&userid=27718
View this thread: http://www.excelforum.com/showthread...hreadid=472331