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
Column A	Column B

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]2003[/TD]
[TD="align: right"]243[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]2003[/TD]
[TD="align: right"]243[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]2003[/TD]
[TD="align: right"]243[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]1902[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]1902[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]1902[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]1902[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]901[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]901[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]901[/TD]
[TD="align: right"]492[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet5​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C2[/TH]
[TD="align: left"]=IF(AND(A2=A1,B2=B1),C1+1,1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



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!