Advanced Filter for Partial Text

**newbieexceldude** · 12-16-2011, 05:51 AM

Hey guys/gals,

I'm wondering if this is possible...

I want to extract multiple records from a list based on PARTIAL text.

For example, let's call this column A:

brown paper bags
light brown socks
brown suede shoes
blue sweaters
blue jeans
black sweater vest
red blouse

I would like to extract any phrase containing brown or sweater to the same sheet or different sheet.

If it works correctly, I would end up with:

brown paper bags
light brown socks
brown suede shoes
blue sweaters
black sweater

I'm thinking this could be done with Advanced Filter but not sure if can find partial text/position within string?

Any ideas? Also.. I would like to be able to use 10 or more words to extract the phrases if possible.

Thanks in advanced!

**nilem** · 12-16-2011, 06:22 AM

maybe so

Please Login or Register  to view this content.

**newbieexceldude** · 12-16-2011, 07:43 PM

Thanks Nilem,

I appreciate your time and effort.

The macro worked perfectly for the example that I gave you. Unfortunately, it was not accurate when I used different data. I had 650 unique phrases in Column A and tried to extract records based on 5 different words.

Thanks for trying though.

**martindwilson** · 12-16-2011, 07:51 PM

advanced filter will do it use wild card * in your criteria, heres yours filtered and copied to sheet 2

**newbieexceldude** · 12-21-2011, 12:59 AM

Thanks Martin,

The wildcard + filter is almost what I was looking for. I'd like to do it with a macro, but this works for now.

Thanks for your help!