1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search text within Text

Discussion in 'Ask an Excel Question' started by msharma864512, Feb 12, 2019.

  1. msharma864512

    msharma864512 Member

    Messages:
    138
    Hi,

    I want to search a certain set of keywords within a data range. And whenever the desired keywords are mentioned in the data range, please filter them or add a column after B to differentiate the companies wherein the keywords are present and where keywords are not present.

    Regards,
    Manish

    Attached Files:

  2. Nebu

    Nebu Excel Ninja

    Messages:
    2,141
    Hi:

    May be this?

    Thanks

    Attached Files:

  3. msharma864512

    msharma864512 Member

    Messages:
    138
    Hi Nebu,

    Thanks for the quick response and this is really very helpful.

    But in this case, it is returning the text which is matching the range.

    Will it be possible to just return Include/Exclude only.
  4. Nebu

    Nebu Excel Ninja

    Messages:
    2,141
    Hi:

    Wrap the formula in a if condition like If(istext(formula), "Include","Exclude")

    Thanks
    DNY likes this.
  5. msharma864512

    msharma864512 Member

    Messages:
    138
    T
    Thats perfect, very helpful, thank u vei much.

Share This Page