Excel Masters! Advanced Filtering Using Lists, How?

Hi all,

Here's the problem that I can't solve.

You have List A:

prices
rentals
holidays

You have List B:

cabin supplies
log cabin
cabin rentals
cabin holidays
green cabins
house cabins
cabin prices
wood prices
cabin homes

What I want is to filter out in list B any of the words from list A (they do not have to match exactly, just one word needs to match so "cabin prices" would be filtered out by "prices"). The results would then look like this:

cabin supplies
log cabin
green cabins
house cabins
cabin homes

I need to do this for a large list of data, but this example simplifies things. This is far too complicated for me but some of you excel gurus out there might be able to solve the problem!

Any ideas?

Thanks.

You could selection the word from list A and run this code, if it helps any? Assumes List B is in Column B.

Please Login or Register  to view this content.