+ Reply to Thread
Results 1 to 5 of 5

Counting groups in a list

  1. #1
    Registered User
    Join Date
    09-03-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    14

    Counting groups in a list

    Attachment 199784Hi all, i have attached a file to better describe my issue, essentially I would like to count all the 'A's, all the 'B's and so on in the file and have the count next to it, so something like

    A 6
    B 3
    D 5
    F 1

    In the file I uploaded I have column B as a count of the numbers, is there a way I could get just the final number for each letter, that would solve my problem. But if there is a simpler more elegant way then please let me know

    Thanks
    Attached Files Attached Files
    Last edited by ghellers; 12-12-2012 at 12:25 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Counting groups in a list

    Are you sure you attached the correct file? I can't figure out what you want to calculate from the example.
    Perhaps if you reposted it with the results you want to see.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    09-03-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Counting groups in a list

    Apologies, I did upload the wrong one, should be corrected now

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Counting groups in a list

    Much better...
    With
    D2: a letter...A

    This regular formula returns the count of that letter in Col_A
    E2: =COUNTIF($A$2:$A$20,D2)

    Is that something you can work with?

  5. #5
    Registered User
    Join Date
    09-03-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Counting groups in a list

    that is perfect, thanks, much simpler than my long winded way using loads of if statements

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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