+ Reply to Thread
Results 1 to 3 of 3

Count number of time a word is in a grid

  1. #1
    Registered User
    Join Date
    05-04-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    Count number of time a word is in a grid

    Hi all

    I have an Excel query, if anyone could help me with it, I would be much obliged.

    I have a set of initials in a grid:


    AA AB AC
    AA AB AC
    AA AB AC
    AA AB AC
    AA AB AC
    AA AB AC
    AV AN AC

    I want to use an Excel formula to give a report of the number
    of instances of each entry, for example:

    AA 5

    AB 5

    AC 6

    AN 1

    AV 1

    If I put the data into a single column, I can do this with a pivot table.
    But there is a lot of data either side of the entries, also it takes
    ages to format the each column into a single column that is suitable for
    pivot table work.

    I'd like to be able to select the data and use a formula to do the counting.

    Does anyone know a formula that will do this?

    Thanks

    Barney

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,400

    Re: Count number of time a word is in a grid

    Hi,

    If you have a predetermined list of all initials that can possibly appear then just use a simple

    =COUNTIF(your_grid_range,A1)

    Where A1 is one of your initials
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-04-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Count number of time a word is in a grid

    Hi

    Thanks for that. I actually don't have a predetermined list of all initials. The list just comes from another system, and is
    different each time.

    Thanks for the suggestion though

+ 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] help need formula to count number with word
    By jericho143 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-15-2015, 04:46 AM
  2. Count Time I post a Word
    By rolive in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2015, 03:29 PM
  3. Number from rota time sheet into grid using time
    By Fordy_deluxe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2015, 04:21 AM
  4. Replies: 6
    Last Post: 11-26-2014, 10:35 PM
  5. [SOLVED] Count word/number without criteria
    By thisisgerald in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2012, 06:22 AM
  6. Replies: 2
    Last Post: 07-12-2012, 12:05 PM
  7. Count each time a word is used throughout chart
    By Rockter in forum Excel General
    Replies: 2
    Last Post: 01-06-2008, 03:31 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