Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Match Function arguments | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |