+ Reply to Thread
Results 1 to 3 of 3

Lookup a repeated word

Hybrid View

Stews Lookup a repeated word 05-21-2013, 03:44 PM
majosum Re: Lookup a repeated word 05-21-2013, 04:31 PM
Stews Re: Lookup a repeated word 05-22-2013, 06:18 AM
  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2011
    Posts
    54

    Wink Lookup a repeated word

    hi excelers,
    I simply need help to find a repeated word across two arrays i.e:

    A1
    Boy
    Cat
    Dog

    B1
    Dog

    C1
    = 1

    (if others words are find it should = 2)

    the solution should be a simple one, hope its explained clearly for you... thanks for any further help.

  2. #2
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Lookup a repeated word

    When you enter this formula, be sure to hold down CTRL+SHIFT+ENTER instead of only ENTER.

    =IFERROR(COUNT(MATCH($A$1:$A$3,$B$1:$B$3,0)),0)

  3. #3
    Registered User
    Join Date
    11-18-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2011
    Posts
    54

    Re: Lookup a repeated word

    thanks, it works...
    but I need it to also work with a block array of words from say A1:C3 etc... via two blocks.

+ 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