+ Reply to Thread
Results 1 to 4 of 4

Counting frequency a text appears in a cell within a column

  1. #1
    Registered User
    Join Date
    07-21-2017
    Location
    NY
    MS-Off Ver
    16.0
    Posts
    25

    Counting frequency a text appears in a cell within a column

    Hi Everyone,

    I've been working on a project for fun and I'm struggling to type a formula to count the number of times a text appears in a different cell within that column.

    Please see attached for an example. Been trying COUNTIFs and VLOOKUPs, etc. but to no success. Help with the formula would be greatly appreciated!

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,891

    Re: Counting frequency a text appears in a cell within a column

    Hi
    are you using Excel for Mac? If so please update your profile accordingly. Thanks

  3. #3
    Registered User
    Join Date
    07-21-2017
    Location
    NY
    MS-Off Ver
    16.0
    Posts
    25

    Re: Counting frequency a text appears in a cell within a column

    Hi Pepe,

    I'm using Excel for Windows. I don't believe my profile mentions Mac anywhere.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,807

    Re: Counting frequency a text appears in a cell within a column

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ 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] Frequency & Counting instances of specific text
    By moneypennie21 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-24-2020, 10:03 AM
  2. Replies: 2
    Last Post: 11-08-2016, 09:08 AM
  3. Counting the frequency of words within a column
    By miloo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2015, 01:33 PM
  4. Replies: 1
    Last Post: 12-10-2013, 05:23 PM
  5. [SOLVED] Counting frequency of Large Spreadsheets of text
    By wholemilk in forum Excel General
    Replies: 4
    Last Post: 07-22-2012, 11:29 AM
  6. Replies: 2
    Last Post: 10-11-2011, 08:15 AM
  7. Replies: 2
    Last Post: 01-20-2009, 08:24 AM

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