+ Reply to Thread
Results 1 to 3 of 3

Need to perform a simple check with letters in two words... again!

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2003
    Posts
    12

    Smile Need to perform a simple check with letters in two words... again!

    Some while ago, an experienced member helped me out with a similar task I had to deal with. Thank you so much "Jakobshavn"
    So here is a new similar task that challenges me.
    It seems that once again I do not get anywhere with my tries, so I think a few lines of VBA scripting is needed to do the job.

    Cell A2 contains one word max length 20 chars.
    This word should be checked against an other word, if any of its letters exists in the other word.
    The other word (to which is compared), resides exactly above, in cell A1.
    A simple check with true/false result.

    If some "weird" alphabet function will be used, please have in mind that I need to do that in Greek language-characters (24 letters).
    Thanks guys.
    This forum is awosome.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Need to perform a simple check with letters in two words... again!

    Not sure if it will work with Greek, but you could try this:

    =SUMPRODUCT(--(ISNUMBER(FIND(MID(A2,ROW(INDIRECT("1:" & LEN(A2))),1),A1))))>0

  3. #3
    Registered User
    Join Date
    08-24-2012
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2003
    Posts
    12

    Thumbs up Re: Need to perform a simple check with letters in two words... again!

    Hi Andrew-R.
    It works fine
    Very complex thinking! You are a genius.
    Thank you very much.
    Happy holidays!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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