EXCEL LOGICAL FORMULA, PLEASE HELP!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan - 06 Mar 2007 15:35 GMT

In one column I have like 2000 email addresses my potential clients
and some of them do not want to receive any emails at all. So I have
about 10 email address that I can not send to. Can someone please help
me with a formula that will eliminate all of those restricted (10
emails) addresses from that main column?
Thank you.
Jan

Reply to this Message

Bernard Liengme - 06 Mar 2007 15:52 GMT

1) delete them
2) move them to another column
3) use a helper column with 0, 1 (0 meaning do not email); use this to
filter on
4) change @ to % so the email goes no where
....
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> In one column I have like 2000 email addresses my potential clients
> and some of them do not want to receive any emails at all. So I have
[quoted text clipped - 3 lines]
> Thank you.
> Jan

Reply to this Message

Jan - 07 Mar 2007 02:38 GMT

On Mar 6, 10:52 am, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:

> 1) delete them
> 2) move them to another column
[quoted text clipped - 15 lines]
> > Thank you.
> > Jan

Thank you guys, you've helped me a lot.
Jan

Reply to this Message

bj - 06 Mar 2007 15:52 GMT

if your main list is in column A and you have a sub list for the ones you
want to remove in column C (C1:C10 for example)
in B1 enter
=if(iserror(vlookup(A1,C$1:C$10,1,0)),"",1)
copy down to the end of your data
select column B
use <data><Filter><auto filter>
select 1 from the autofilter arrows
Select all the cells in column A next to a 1
delete or move as you wish.

> In one column I have like 2000 email addresses my potential clients
> and some of them do not want to receive any emails at all. So I have
[quoted text clipped - 3 lines]
> Thank you.
> Jan

Reply to this Message