Results 1 to 5 of 5

Advanced Filter for Partial Text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Advanced Filter for Partial Text

    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!
    Last edited by newbieexceldude; 12-21-2011 at 01:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1