Ongoing count of occurrences in cells

[Kaemluto]

[TABLE="width: 75"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AAA123
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]BBB123[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]BBB123[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]BBB123[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]CCC123[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]CCC123[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]DDD123[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]DDD123[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]DDD123[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]DDD123[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]


I basically need a formula to get me a running count of variables in Col A??? Stumped

 

[jtakw]

Hi,

Not sure what you mean, may be this:

Book1
	A	B
1	AAA123	1
2	BBB123	1
3	BBB123	2
4	BBB123	3
5	CCC123	1
6	CCC123	2
7	DDD123	1
8	DDD123	2
9	DDD123	3
10	DDD123	4
Sheet74

Cell Formulas
Range	Formula
B1	=COUNTIF(A$1:A1,A1)

Formula copied down.

 

[Kaemluto]

Thats exactly it, couldn't remember it for the life of me. Much appreciated.

-J

 

[jtakw]

You're welcome, welcome to the forum.