How to number instances of a variable?

Thanks again in advance for your help I have found this forum very useful.

I don't know exactly how to word this so ill show an example

I have this data: A date and a variable
1/2/2009 A
1/3/2009 A
1/4/2009 B
1/5/2009 A
1/6/2009 B
1/7/2009 B
1/8/2009 A

etc
I want to have the column next to this data count the instances of A, B etc. So the 2nd A in the list would have a 2 next to it... it would end up looking like this:

1/2/2009 A 1
1/3/2009 A 2
1/4/2009 B 1
1/5/2009 A 3
1/6/2009 B 2
1/7/2009 B 3
1/8/2009 A 4

Is there a simple way to do this with out VBA?

Thanks!

If the letters start in B1, then in C1 and copy down,

=COUNTIF(B$1:B1, B1)

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes