+ Reply to Thread
Results 1 to 4 of 4

Count number of times a specific word appears

  1. #1
    Registered User
    Join Date
    02-05-2016
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    16

    Count number of times a specific word appears

    I would like to count the number of times a name appears in c31:u31 and post the name only once in x16:x26 and the number of times the name appears next to it in z16:z26. Any help with this would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Count number of times a specific word appears

    First unmerge cell X16
    in Cell X16 use:
    {=IFERROR(INDEX($C$31:$U$31,MATCH(0,COUNTIF($X$15:X15,$C$31:$U$31),0)),"")}
    Remember CTRL+SHIFT+ENTER, then copy down to cell X26
    in Cell Y16 use:
    =IF(X16="","",COUNTIF($C$31:$U$31,X16))
    Then copy down

  3. #3
    Registered User
    Join Date
    02-05-2016
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    16

    Re: Count number of times a specific word appears

    Thank you! One last addition to this that I didn't think of: I would like the x16:x26 to exclude No Skin in the count. Is this possible?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,424

    Re: Count number of times a specific word appears

    Quote Originally Posted by csepesy View Post
    I would like the x16:x26 to exclude No Skin in the count.
    This proposed solution builds on the one that we discussed in one of your previous threads and employs two helper columns.
    Column AG is populated by the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Column AH, which breaks ties (test by changing Eric's score on the fifth hole from 2 to 3) is populated by the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    X16 and down is populated by the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Y16 and down is populated by the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] count number of times a word appears
    By m_789 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-19-2013, 10:16 AM
  2. count the number of times a number appears in a specific range
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:01 AM
  3. Count number a times a specific value appears consecutively.
    By kww0027 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2013, 06:17 PM
  4. [SOLVED] Count how many times certain word appears in column
    By micko_escalade in forum Excel General
    Replies: 4
    Last Post: 08-16-2012, 07:55 PM
  5. [SOLVED] Formula to count number of times specific word used in column range
    By flammer4 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-07-2012, 01:42 PM
  6. Count the number of times a specific text appears in column D
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2011, 02:02 PM
  7. count the number of times a specific word appears in a column
    By BAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 12:10 PM
  8. [SOLVED] Count how many times the same word appears in column
    By Alexa in forum Excel General
    Replies: 5
    Last Post: 04-16-2005, 11:07 AM

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