+ Reply to Thread
Results 1 to 2 of 2

Need to know how to count number of repeated words in a list, with lots of different words

  1. #1
    Registered User
    Join Date
    05-18-2018
    Location
    Greenland
    MS-Off Ver
    Up-to-date
    Posts
    1

    Need to know how to count number of repeated words in a list, with lots of different words

    Hi,

    So I need to cumulatively work out the number of times a word is repeated in a multi-word list.

    E.g.

    Bob
    Jill
    Bob
    Bob
    Jill
    Frank
    Bob
    Frank

    I would like code to produce the following numbers:

    0
    0
    1
    2
    1
    0
    3
    1

    So that I can tell how many times each individual has been repeated.

    I have been playing with COUNTIF and FREQUENCY etc. but to no avail.

    All help appreciated. Thanks!

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,088

    Re: Need to know how to count number of repeated words in a list, with lots of different w

    Use this:
    =COUNTIF($A$15:A15,A15)-1

    Lock the first cell in your range and drag down

+ 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. Count number of words refer to the list in a cell
    By chaselok in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2018, 06:41 AM
  2. Replies: 15
    Last Post: 08-07-2017, 02:40 PM
  3. Count number of different words in a list
    By pedro90 in forum Excel General
    Replies: 17
    Last Post: 01-15-2015, 09:50 AM
  4. Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  5. Help! Count how many words in a sentence match a dictionary of words
    By sonyaelis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2013, 05:31 AM
  6. Replies: 3
    Last Post: 11-28-2012, 04:00 AM
  7. Count non-repeated words in cell
    By mxc668 in forum Excel General
    Replies: 10
    Last Post: 10-14-2009, 06:04 PM

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