Complex Counting help

[Aldonin]

Hello there guys!

I have the following list:

B0111531	ALSINA EGEA, ESPERANZA
B0111531	ALSINA EGEA, ESPERANZA
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC
B0111926	PEYPOCH FOCHS, FRANCESC

<tbody>
</tbody>

and I would need to add a number next to each item that is repeated so that it ends up like this:

S562	KESLER	1
B0111531	ALSINA EGEA, ESPERANZA	1
B0111531	ALSINA EGEA, ESPERANZA	2
B0111926	PEYPOCH FOCHS, FRANCESC	1
B0111926	PEYPOCH FOCHS, FRANCESC	2
B0111926	PEYPOCH FOCHS, FRANCESC	3
B0111926	PEYPOCH FOCHS, FRANCESC	4
B0111926	PEYPOCH FOCHS, FRANCESC	5
B0111926	PEYPOCH FOCHS, FRANCESC	6
B0111926	PEYPOCH FOCHS, FRANCESC	7
B0111926	PEYPOCH FOCHS, FRANCESC	8
B0111926	PEYPOCH FOCHS, FRANCESC	9

<tbody>
</tbody>

So basically: for each new item, start counting with "1". If in the next line the item code is repeated then add 1, if its a new item, start again with 1.


I'm sure it will be a piece of cake for some of you, thanks a lot in advance!!

 

[gaz_chops]

Try this in C1 and drag down
=countif($A$1:A1,A1)

 

[BadgerRoad]

assuming the data starts in cell b2 place the following in c2 and copy down:
=IF(B2<>B1,1,C1+1)