Results 1 to 4 of 4

Search for multiple text strings

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2010
    Location
    Virginia
    MS-Off Ver
    Excel 2013
    Posts
    104

    Search for multiple text strings

    What is the best way to search for the presence of a list of text strings?

    Attached is a sample file.

    The "Data records" worksheet contains a data column called "Title" and another column called, "Filter check".

    The "Current filters list" worksheet contains in the "Filters List" column a list of text strings. This list is likely to grow over time.

    I'd like to know the best way to check each Title field in the Data records worksheet for the presence of any of the text strings in the Current filters list worksheet's Filters List.

    For example, the first Filters List value is "happy cow". Since *happy cow* is not contained in any of the Title values in the Data records worksheet, it should not get a value in the Filter check column. However, the 4th and 5th records in the Data records worksheet should get a "Yes" in the Filter check column, because they both do contain text strings that are included in the Current filters list worksheet's Filters List column.

    I've used SEARCH to search for single strings within strings, but I don't know the best way to handle this situation. My actual list of filters is about 15 - 20 different text strings.

    Can someone help me with this?

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