+ Reply to Thread
Results 1 to 3 of 3

Counting Frequency

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    New Orleans, Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting Frequency

    Hi all - Newbie here. I have a problem I hope you all can help me with. Have a column of data that I want to count the frequency on. i.e.:

    Bob
    Bob
    Jim
    Bob
    Mary
    Jim
    Bob

    I can run the Countif() function, which sorted will make it look like this:

    Bob 4
    Bob 3
    Bob 2
    Bob 1
    Jim 2
    Jim 1
    Mary 1

    Would like it to read:

    Bob 4
    Bob 4
    Bob 4
    Bob 4
    Jim 2
    Jim 2
    Mary 1

    Any Ideas?

    SD

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Counting Frequency

    countif gives the later result only. see the attachment.
    Attached Files Attached Files
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  3. #3
    Registered User
    Join Date
    05-02-2011
    Location
    New Orleans, Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Counting Frequency

    Thx John. Told you I was a newbie. Using your example, I had =COUNTIF(D3:D9,D3) instead

+ 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