Counting Formula

[Rosa94]

Hello Wonderful Helpers,

I'm wondering if there is a formula that can count until a leading cell changes content. When the cell changes it starts back at 1?? I need to do this on a large scale.
For example:
[TABLE="width: 84"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Fox[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Fox[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Mouse[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Bird[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Horse[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chicken[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Chicken[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Chicken[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Fish[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]


You all are amazing! Thank you so much for your help.

 

[Fluff]

How about
=COUNTIF($A$2:$A2,A2)

 

[Rosa94]

AMAZING!!!!! can you tell me or send me a link to see how this formula works?

 

[Fluff]

You're welcome & thanks for the feedback.

Either look at the MS help for the function, or google it