+ Reply to Thread
Results 1 to 7 of 7

Cell value, and respective count. (for statistical and graphic use)

  1. #1
    Registered User
    Join Date
    08-04-2016
    Location
    assen
    MS-Off Ver
    MS 0FFICE 2016
    Posts
    5

    Cell value, and respective count. (for statistical and graphic use)

    Hello everyone,

    I need to count each cell value, and have their respective value. For example:
    CHEESE
    CHEESE
    ONION
    ONION
    APPLE
    CHEESE
    APPLE
    CHEESE
    APPLE
    ONION

    ---------------------------
    Cheese 4
    Onion 3
    Apple 3


    Many thanks in advance,
    Ciano Huang

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,352

    Re: Cell value, and respective count. (for statistical and graphic use)

    A pivot table where
    "food" is the row label and
    "count of food" is in the values field.

    Basic intro to creating pivot tables: http://www.excel-easy.com/data-analy...ot-tables.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-04-2016
    Location
    assen
    MS-Off Ver
    MS 0FFICE 2016
    Posts
    5

    Re: Cell value, and respective count. (for statistical and graphic use)

    Does this apply for a research/statistical sheet?
    This means i have a sheet1 with information, and sheet 2 with the stats.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Cell value, and respective count. (for statistical and graphic use)

    If that doesn't work for you,try countifs
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,352

    Re: Cell value, and respective count. (for statistical and graphic use)

    The basic pivot table tools can compute count, average, max, min, standard deviation, and variance, among other things. Your OP only asked about counting words, with no other context or detail about what you need this analysis to do. The results of a pivot table can be fed into other formulas and functions to perform further calculations. A pivot table can be a good way to analyze data and to get the data needed for further analysis. Beyond that, I'm not sure much can be said without understanding more of the context around this calculation you are trying to perform.

    As Ford noted, most pivot table calculations can also be acheived through other worksheet functions. That can be preferable in many contexts. One would need to understand where this "count" operation fits into your larger analysis algorithm.

  6. #6
    Registered User
    Join Date
    08-04-2016
    Location
    assen
    MS-Off Ver
    MS 0FFICE 2016
    Posts
    5

    Re: Cell value, and respective count. (for statistical and graphic use)

    Thanks guys, im a little bit further now.

    Still got a few questions:

    Datasheet1 contains a lot of different data and has multiple column names :

    Header empty for clarity purposes header header
    Header in chinese Header in chinese Header in chinese
    values values values

    Now when i select the data it doesn't work, i had to delete the chinese translation row, as a temporary solution.
    Also I need a better way to split the table caches, to make groups.
    At the moment i press ALT+D+T or something and then change the range, and then change it back.

    What are ways to SELECT the whole datasheet mentioned above for dynamic tables.

    Thanks in advance.
    Last edited by cianohuang; 08-04-2016 at 09:34 PM.

  7. #7
    Registered User
    Join Date
    08-04-2016
    Location
    assen
    MS-Off Ver
    MS 0FFICE 2016
    Posts
    5

    Re: Cell value, and respective count. (for statistical and graphic use)

    @mrshorty

    I am trying to, with a emphasis on trying to understand our business.
    The goal is to get more knowledge, information and insight.
    For now i made some graphs and some tables, which are great. Im hoping i can further learn how to use this function and implement it into the datasheet for next year.

+ 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. Replies: 5
    Last Post: 04-07-2016, 03:34 AM
  2. Replies: 14
    Last Post: 01-25-2015, 06:12 AM
  3. [SOLVED] Row highlighted with respective of cell
    By kumawat_s in forum Excel General
    Replies: 1
    Last Post: 08-14-2014, 07:03 AM
  4. Replies: 1
    Last Post: 11-26-2013, 11:55 AM
  5. Replies: 15
    Last Post: 08-24-2013, 10:05 AM
  6. Statistical functions: count but disregard duplicates
    By voodoomusic in forum Excel General
    Replies: 3
    Last Post: 04-19-2009, 07:59 PM
  7. Any way to center a graphic in a particular cell?
    By metalsped in forum Excel General
    Replies: 8
    Last Post: 05-06-2006, 02:00 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