+ Reply to Thread
Results 1 to 4 of 4

Counting Question

  1. #1
    Registered User
    Join Date
    06-02-2009
    Location
    NJ, USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Counting Question

    I want to count the number of similar cells with a rolling number, for example:

    abc 1
    abc 2
    abc 3
    xyz 1
    xyz 2
    aaa 1
    aaa 2
    aaa 3
    aaa 4

    First column is my data. Second column would be how many times that value shows on a counting basis. How do I get the numbers in the 2nd column? I know its some sort of countif statement but I can get it to work.

    I was thinking something like =countif(A1:A9,A1=A2) or something along those lines but I just can't quite get it right. Any help, I couldn't find this exact circumstance by searching here.

  2. #2
    Registered User
    Join Date
    06-02-2009
    Location
    NJ, USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Counting Question

    Thanks a bunch, I had my order messed up. I appreciate it!

+ 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