row count

[upcea]

I am wondering if there is a way to count the number of rows I have with specific data.

For example:
A
A
A
A (next column it would read "4")
B
B (next column would read "2")
123
123
123
123
123
123 (next column would read "6")

etc. is there a way?

 

[machopicho]

Try:
=IF(A1=A2,"",COUNTIF(A$1:A$12,A1))