I am filtering a large database of addresses before doing a mailout. I have a list of about 30 words in column A (A2:A31) that, if any are present in the organization's name (C2:C27365), I do not want to mail to them.
How do I write a formula that goes through the list of the organization's names (C2:C27365) to 1) see if it has any of the words from the filter list (A2:A31), and 2) place an "x" (or TRUE or FALSE or anything to alert) in the cell to the immediate left (Column B) to flag the presence of a filter word? That way I can autofilter Column B and then delete all the rows with an "x" in Column B.
Your help greatly appreciated!
How do I write a formula that goes through the list of the organization's names (C2:C27365) to 1) see if it has any of the words from the filter list (A2:A31), and 2) place an "x" (or TRUE or FALSE or anything to alert) in the cell to the immediate left (Column B) to flag the presence of a filter word? That way I can autofilter Column B and then delete all the rows with an "x" in Column B.
Your help greatly appreciated!