+ Reply to Thread
Results 1 to 4 of 4

how do I count the number of times a word is repeated in a range?

  1. #1
    sol
    Guest

    how do I count the number of times a word is repeated in a range?



  2. #2
    Forum Contributor keithl816's Avatar
    Join Date
    03-18-2005
    Location
    Georgia
    MS-Off Ver
    2000
    Posts
    188
    Try here

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=235
    or here
    http://www.vbaexpress.com/kb/kblist.php

    Hope this helps

  3. #3
    CLR
    Guest

    Re: how do I count the number of times a word is repeated in a range?

    Adapted from Dave Peterson's fine earlier post...........

    =SUMPRODUCT(LEN(A1:C101)-LEN(SUBSTITUTE(UPPER(A1:C101),UPPER(D1),"")))/LEN(D
    1)

    Vaya con Dios,
    Chuck, CABGx3


    "sol" <[email protected]> wrote in message
    news:[email protected]...
    >




  4. #4
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    I use =COUNTIF(D10:D100, "YES"). It works pretty good

+ 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