Hi,
I have a range of values in Column A (A4:A500) which have hundreds of detailed product descriptions, these descriptions vary but will always contain a keyword. I want to narrow this list down to one or two key products. Is there a way I can delete all rows which don't contain certain keywords. To keep things simple, lets say I wanted to keep all descriptions which contain "apple" or "pear".
Anyone know how I might do this so I can make it in to a macro. I've tried to use advanced filter but as descriptions vary I can't can't make it filter results which just contain specific words. Help would be much appreicated.
Bookmarks