counting the number of times a number appears in a list

[bearcub]

I was working on a project where I have items that appear in a list multiple times. They are all sorted alphabetically and I wanted to get a formula that would count it appears while going down each row.

If had a list of 3 items in Range(A1:A3) I would have a formula in column B that would increment by 1 for each time it appears after the 1st occurence.

Col A  col B
A        1
A        2
A        3 
B        1
B        2
B        3 
C        1
C        2
C        3

This is the pattern that I would like to see in Col B. I tried using Countifs but I forgot how to increment it after the 1st occurence and start over again when the value in Col A changes.

Thank you for your help

Michael

 

[offthelip]

try this:

=COUNTIF(A$2:A2,A2)

and copy down

 

[Michael M]

to increment the COUNTIF use

=COUNTIF($A$1:A1,"A")

and copy down.
Obvioulsy this will only work in the instance of "A"

 

[bearcub]

thank you, that was the formula. I was using ">1" for the second argument.