How write formula contains words
Results 1 to 3 of 3

Thread: How write formula contains words
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2015
    Posts
    114
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post How write formula contains words

    Hi,

    i'm having description column it contains as sentences in that if it contains word ("Critical,JOBFAIL") and also in the description sentences which doesn't contain"JOB" also want to set as "Alert" remaining all i want set as "Batch"

    how to writ formula for this. can tell me

  2. #2
    Board Regular Fishboy's Avatar
    Join Date
    Feb 2015
    Location
    UK
    Posts
    4,261
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How write formula contains words

    Quote Originally Posted by baskar5353 View Post
    Hi,

    i'm having description column it contains as sentences in that if it contains word ("Critical,JOBFAIL") and also in the description sentences which doesn't contain"JOB" also want to set as "Alert" remaining all i want set as "Batch"

    how to writ formula for this. can tell me
    Hi baskar5353,

    I have tried to read this several times and now my head hurts. I am afraid you may need to re-explain your problem a little clearer to get help, ideally showing us some example data. If you Google MrExcel HTML Maker you can copy and paste some example data directly onto the forums for us to see what you are talking about.

    I hope this at least gets you moving in the right direction.
    REMEMBER: Always test out new code / formulas in a COPY of your worksheet as some actions CANNOT be undone by clicking the "Undo" button

    If you need to share example data, a number of useful items including the Mr.Excel HTML Maker
    can be found here.

    If someone took the time and helped you to solve your issue remember to click the "Like" button on their post to make it easier for others for find the right solution, plus a little gratitude goes a long way!

  3. #3
    Board Regular
    Join Date
    Dec 2009
    Location
    Yorkshire, UK
    Posts
    87
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How write formula contains words

    Perhaps:

    =IF(SUMPRODUCT(--ISNUMBER(SEARCH(KeywordTable,E2))),"Alert","Batch")

    Where KeywordTable is a named range containing all keywords.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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