How to I advance filter to remove rows containing partic string of text?

D

Dave

Is this possible?

I know how to filter to include strings of text but I don't know how
to filter so that rows containing a certain email address domain name
are not visible in the filetered results.

Many thanks if anyone's able to assist!

Dave
 
F

Frank Kabel

Hi
one way: use a helper column with a formula like
=IF(ISNUMBER(FIND("domain.com",A1)),1,0)
and filter with this column
 
P

Paul Falla

Dear Dave

Set the Auto filter feature on, then on the column header
for the column that contains the domain names, select
custom from the drop down. In the first drop down in the
dialogue box, select Does not contain from the list and
then in the second box either select the relevant name
from the list or type it straight in.

Hope this helps

Paul Falla
 
D

Debra Dalgleish

In the criteria area, add the same heading as in the source table, for
the column that contains the email address.
In the cell below, use the not equal operator: <>
and the * wildcard character with the email address.
For example:

Email
<>*microsoft.com*
 
Top