+ Reply to Thread
Results 1 to 4 of 4

text counting w/ wildcards

  1. #1
    Registered User
    Join Date
    02-27-2008
    Location
    Irving, Texas
    MS-Off Ver
    MS Office 2016
    Posts
    96

    text counting w/ wildcards

    I feel like I know how to do this, but nothing I'm trying is working for me.

    I have a listing of words in Column D, and a list of wildcard values I want to count in Column E. I want to make a value in Column F that says TRUE/FALSe based on whether or not the wildcard match the word. Somewhat like this
    D E F
    bat *at* TRUE
    bats *og* TRUE
    cats TRUE
    dog TRUE
    frog TRUE
    frogs TRUE
    fish FALSE
    bird FALSE

    I tried
    Please Login or Register  to view this content.
    copied down the F column, but it's not working and I'm not sure why.

    This is really obvious and I know I'll feel dumb when someone helps me

    Thanks in advance,
    Adam
    Last edited by ahartman; 03-08-2010 at 11:50 AM. Reason: Solved by DonkeyOte
    -Adam Hartman
    Mechanical Engineer

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: text counting w/ wildcards

    It seems a bit complicated but this works

    =IF(NOT(ISERROR(SEARCH(E$1,D1))),"True",IF(NOT(ISERROR(SEARCH(E$2,D1))),"True","False"))

    copied down column F
    Last edited by Huron; 03-06-2010 at 06:04 AM. Reason: changed D4 to D1

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,529

    Re: text counting w/ wildcards

    Perhaps

    F1: =ISNUMBER(LOOKUP(9.99E+307,SEARCH($E$1:$E$2,$D1)))
    copied down

    The reference to E1:E2 can be made to be dynamic if needed.

    (if you want the Boolean as literal text string - ampersand a Null to the result)

  4. #4
    Registered User
    Join Date
    02-27-2008
    Location
    Irving, Texas
    MS-Off Ver
    MS Office 2016
    Posts
    96

    Re: text counting w/ wildcards

    Quote Originally Posted by DonkeyOte View Post
    Perhaps

    F1: =ISNUMBER(LOOKUP(9.99E+307,SEARCH($E$1:$E$2,$D1)))
    copied down

    The reference to E1:E2 can be made to be dynamic if needed.

    (if you want the Boolean as literal text string - ampersand a Null to the result)
    This worked like a charm. Thanks yet again, DonkeyOte!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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