Count Unique Data VB or Formula

[Tchase01]

I am having trouble finding a formula or VB macro to Count a Unique value in Column A and put the count in column C count them down until it finds another unique value in column A and starts the count over again etc...
Windows 7 Office 2013


Columns
A B C
2003 243 1
2003 243 2
2003 243 3
1902 492 1
1902 492 2
1902 492 3
1902 492 4
0901 492 1
0901 492 2
0901 492 3

 

[Eric W]

Welcome to the forum.

Try this:

	A	B	C
1	Column A	Column B
2	2003	243	1
3	2003	243	2
4	2003	243	3
5	1902	492	1
6	1902	492	2
7	1902	492	3
8	1902	492	4
9	901	492	1
10	901	492	2
11	901	492	3
12

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

Worksheet Formulas Cell Formula C2 =IF(AND(A2=A1,B2=B1),C1+1,1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Put the formula in C2, then copy down. Let me know if this works.

 

[Tchase01]

Welcome to the forum.

Try this:Put the formula in C2, then copy down. Let me know if this works.

Thank You Eric W that does work great..was drawing blanks on how to make it work....

Thanks Again

 

[Eric W]

Glad to help!