Hi,
I'm trying to flag records that CONTAIN any of the strings in another
range. My purpose, in this specific case, is to examine a range of
website URLs and to remove any URLs belonging to particular domains.
For example:
ColumnA: List of URLS
www.sports.cnn.com/basketball.htm
www.aaa.baddomain.com/trouble.htm
www.groups.google.com/excel/
www.nothanksdomain.com
http://www.trouble.dontwantdomain.or...ouble/go/away/
ColumnB: List of domains to suppress
baddomain.com
nogooddomain.net
dontwantdomain.org
nothanksdomain.com
ColumnC: Result
I'm looking for a formulae that identifies if there is a LIKE match
between ColumnA and ColumnB and outputs TRUE/FALSE (or similar).
Thanks
Dean
Bookmarks