+ Reply to Thread
Results 1 to 5 of 5

Checking text between cells

  1. #1
    Registered User
    Join Date
    07-17-2015
    Location
    Poole
    MS-Off Ver
    2013
    Posts
    3

    Checking text between cells

    Hi,

    Could somebody please explain a simple way to check if there is a text entered in more than one cell (in a set of three), and if there is, whether it is identical?

    For example:

    A3 = Sunday D3 = "" G3 = Sunday

    Value would be "Yes"

    A3 = Sunday D3 = "" G3 = Monday

    Value would be "No"

    Thanks for your help

    Jon

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Checking text between cells

    Why is return for first example Yes and second example is No ?
    All thats changed is the day.

    Based on your description both examples should return Yes

    "if there is a text entered in more than one cell (in a set of three)"
    There is text enetered in more than one cell in both cases so both values should be "Yes"

    If not, please explain why.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-17-2015
    Location
    Poole
    MS-Off Ver
    2013
    Posts
    3

    Re: Checking text between cells

    Hi Special K,

    Thanks for replying.

    The first check is to see if there is text entered into more than one cell.

    The second check is to see if the text entered is identical

    First example, both are Sunday, so return is "Yes"

    Second example, text entered is different, so return is "No"

    Regards

    Jon

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Checking text between cells

    This should work

    =IF(AND(COUNTA(A3,D3,G3)>1,OR(A3=D3,A3=G3,D3=G3)),"Yes","No")

    If (A3 and D3 or A3 and G3 or D3 and G3 are the same) and more than one of those cells has been enetered then Yes otherwise No

  5. #5
    Registered User
    Join Date
    07-17-2015
    Location
    Poole
    MS-Off Ver
    2013
    Posts
    3

    Re: Checking text between cells

    That's perfect, thank you for your help!

+ 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] Checking of cells with other cells (text)
    By X-L in forum Excel General
    Replies: 10
    Last Post: 04-18-2016, 08:39 PM
  2. Checking text in cells against a list of possible words
    By robcmar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-27-2013, 04:20 PM
  3. Replies: 1
    Last Post: 10-27-2012, 12:04 PM
  4. Checking cells for 2 text strings
    By Phillycheese5 in forum Excel General
    Replies: 4
    Last Post: 10-04-2010, 10:25 AM
  5. Checking multiple cells for text.
    By matt20687 in forum Excel General
    Replies: 5
    Last Post: 07-16-2010, 06:55 PM
  6. Checking two cells for text, returning one value
    By sdaddy in forum Excel General
    Replies: 4
    Last Post: 06-09-2009, 02:49 AM
  7. Checking text across a range of cells
    By thebluemask in forum Excel General
    Replies: 4
    Last Post: 10-09-2008, 06:34 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1