Take the 2-minute tour ×  I have tried finding this solution on
the web but have not had success for this specific problem. In
Excel 2010 I have some data in column A where each value may
partially contain data in column B.  Column A might contain
"http://google.com/webmasters" Column B might contain
"google.com" This should give me a match.  I want to print in
Column C all values in column A that do not contain any values
from column B.  Column A   Column B   Column C (results
required)   Any help would be greatly appreciated.
share|improve this question Do you just want an elegant
solution? You could easily do this using a loop within a loop – 
CAPSLOCK Jan 23 '13 at 16:49 add comment  2 Answers  up vote 0
down vote accepted  I think I have the solution using ARRAY
formula. Assuming your input AND that columns A-C have titles,
or simply, strings are listed starting cells A2 and B2, do the
following:    1. C2: type the formula =IF(OR(NOT(ISERROR(SEARCH(
INDIRECT("B2:B"&(COUNTA($B:$B))),$A2)))),"",$A2) but pr