+ Reply to Thread
Results 1 to 4 of 4

Check non aligned cells for specific text

  1. #1
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    129

    Check non aligned cells for specific text

    Dear Forum.

    I am trying to find a formula that is checking various cells for specific text. The solutions I've seen (ISNUMBER or COUNTIF) only show the formulas for if the cells that you are checking are adjacent (e.g. A12:A26). However in my case the cells that I'm looking to check are not next to each other.

    For the example of the screen shot below… I’m looking for a formula for cell E5. That formula would look in cells A10,A11,C10,C11,F10,F11 for the word “Paint”. If the word “Paint does exist in any of those ceils then I want the word “Yes” to be shown in cell E5.

    Thank you.


    ExcelContainTextScreen.jpg
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-09-2010
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Check non aligned cells for specific text

    =IF(OR(E10="Paint",E11="Paint",G10="Paint",G11="Paint",J10="Paint",J11="Paint")=TRUE,"Yes","No")

  3. #3
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Check non aligned cells for specific text

    Perfect Flyer_man!
    Thank you very much!!

  4. #4
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Check non aligned cells for specific text

    I'm having a problem marking this thread as solved. When I go to Edit the original post to change the Prefix to "Solved" - the original text is gone. When I go to advanced it is also not there. If I try to mark as solved and Post - I get a error message warning me that my message has less than the required entry (since none of the original text is there).
    I was also having difficulty attaching files. The only way I was able to attach the file was by using the attach image feature rather than the paperclip that I have used in the past.
    Is it more likely something going on with the website or me? If on my end - any suggestions? Can someone (Administrator) mark this thread as Solved until I can resolved?

+ 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. [SOLVED] If cell has specific text, check to see if two other cells match
    By dvs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2015, 05:20 PM
  2. Replies: 3
    Last Post: 05-17-2015, 04:01 AM
  3. [SOLVED] Check if 2 cells contain the same specific text
    By Verifyor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2014, 06:28 AM
  4. possible to check for file in multiple folders, then check for values in specific cells?
    By mattheritage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 08:33 AM
  5. [SOLVED] Cells values to be check and replace with specific text
    By amolryeolekar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 02:44 AM
  6. Replies: 3
    Last Post: 11-29-2012, 11:52 PM
  7. Replies: 1
    Last Post: 11-28-2012, 11:04 PM

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