+ Reply to Thread
Results 1 to 6 of 6

How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"

  1. 10-18-2013, 07:42 PM #1
    benitopjuarez
    benitopjuarez is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Berkeley, CA
    MS-Off Ver
    Excel 2003
    Posts
    5

    How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"

    How can I check if a range of cells along a row contain the word "unresponsive" and then return either "yes" or "no"

    Thanks!
    Reply With QuoteRegister To Reply
  2. 10-18-2013, 07:51 PM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: How to check if a range of cells contains the word "unresponsive" and return "yes" or

    G'day

    If this is based on, if there is only one word to one cell. Try this
    Please Login or Register  to view this content.
    Remember to adjust the countif range to suit your own layout.
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it
    Reply With QuoteRegister To Reply
  3. 10-18-2013, 08:15 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to check if a range of cells contains the word "unresponsive" and return "yes" or

    Here's another one:

    =IF(COUNT(MATCH("unresponsive",A1:J1,0)),"Yes","No")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 10-18-2013, 10:39 PM #4
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: How to check if a range of cells contains the word "unresponsive" and return "yes" or

    welcome to the forum, benitopjuarez. the word "contain" is very sensitive. i would label these texts as containing the word "unresponsive"
    they are unresponsive
    unresponsive clients
    an unresponsive person

    so if those of the above are to be considered, then add wildcards to both ratcat's & Tony's solutions:
    =IF(COUNTIF(A1:Z26,"*Unresponsive*")=0,"No","Yes")
    =IF(COUNT(MATCH("*unresponsive*",A1:J1,0)),"Yes","No")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
  5. 01-22-2014, 01:34 AM #5
    willie11
    willie11 is offline
    Registered User
    Join Date
    01-21-2014
    Location
    america
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: How to check if a range of cells contains the word "unresponsive" and return "yes" or

    Sweet Jesus yes. Thank you.

    I'd been looking furiously for hours upon hours trying to figure this out and your formula worked PERFECTLY.

    THANK YOU.
    Reply With QuoteRegister To Reply
  6. 01-23-2014, 11:02 AM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to check if a range of cells contains the word "unresponsive" and return "yes" or

    You're welcome. Thanks for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  2. [SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.
    By NeilAZ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2013, 11:53 PM
  3. Return "green", "yellow" or "red" from date/age and priority ranking
    By Cantaloop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 12:12 AM
  4. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  5. Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank
    By DanBraden in forum Excel General
    Replies: 3
    Last Post: 02-16-2011, 02:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1