Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Process a row if a string search finds certain words from a list
Hello!
I have a list of real estate ads (text) in a column (column B). It has over 300 rows. I want to delete every row that has certain pre-defined words in the ad text; eg. realtor, property, management, etc. The list of words I would like to search for is a variable list that I may add to over time. So I'm thinking of having a separate sheet ("'exclusions") that has all the words i want to look for in its column A. So I would like to have a macro that does the following (below is in pseudo code): for each word in "exclusions"(a:a) do for i= 1 to lastrow do if cell B(i) contains word then delete row end if end for Am I making sense? Again, the ad text is of variable length, and i'm looking to find certain words based on a list located in another sheet that may change. Thanks very much in advance for any/all help! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search a string in a cell for a list of 3 letter codes | Excel Worksheet Functions | |||
search if a string contains text matching items in a list | Excel Worksheet Functions | |||
How do I do a multiple search using key words in a text string | Excel Discussion (Misc queries) | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
need IF function to return 0 if it finds a one out of three words | Excel Worksheet Functions |