Hi Everyone
I have attached a simple test spreadsheet that contains two worksheets.
The first "domainnames" contains a list of domain names. I have included a sample set of 35 rows but there will be maybe 1000 or more.
The second "spamwords" is a list of words that I want to use to remove all rows if any of the words in the "spamwords" list are contained within the "domainnames" worksheet.
So as an example if the word "shoes" in "spamwords" worksheet is present in any of the rows in the worksheet "domainnames I would like the row to be deleted.
In this this example it would remove the rows soccersshoes-usa.com hothotshoes.com & running-shoesby.com from the "domainnames" worksheet
Hope that makes sense
thanks for your time to read this post
Bookmarks