+ Reply to Thread
Results 1 to 3 of 3

Checking that a cell contains a substring when assessing a column

  1. #1
    Registered User
    Join Date
    12-14-2019
    Location
    London, UK
    MS-Off Ver
    O365
    Posts
    6

    Checking that a cell contains a substring when assessing a column

    Hello,
    I have the following formula.

    Please Login or Register  to view this content.
    I want to make a change so that
    Please Login or Register  to view this content.
    returns true if the c:c cell contains "Temaz" as a sub string, rather than equates to it. Ie so that "Temaz" or "Temaz, pregab" both return true. The reason is that the cells now contain other substrings in addition to "temaz" but should still be counted. I've tried using wildcards "*Temaz*" but that doesn't work (gives wrong result).

    I appreciate that the formula uses an array, which is bad practice, but there's not much data to process and it works well so for simplicity I've written it as it is.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Checking that a cell contains a substring when assessing a column

    Perhaps...
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-14-2019
    Location
    London, UK
    MS-Off Ver
    O365
    Posts
    6

    Re: Checking that a cell contains a substring when assessing a column

    That worked Paul, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 03-09-2018, 11:39 AM
  2. Macro to search cells for substring and replace contents of cell if substring is found
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2015, 06:40 AM
  3. Search substring within range, report the substring found
    By Brooke1578 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 03:56 PM
  4. Replies: 2
    Last Post: 06-29-2012, 07:02 AM
  5. [SOLVED] Extract Substring, then Ignore that Substring, while collecting data from Other substrings
    By Sameki121 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2012, 05:21 PM
  6. [SOLVED] VLOOKUP based on a substring in cell to be searched in column
    By Ekser in forum Excel General
    Replies: 7
    Last Post: 04-13-2012, 07:23 AM
  7. Find the sub string in column and copy the cell next to the substring
    By shrujan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2009, 11:00 AM

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