Numbering Duplicate Values as they Occur 1, 2, 3, etc...

[lwthomp80]

I have a list of names that have duplicates. The list is in no particular order and I need to be able to number the duplicates 1, 2, 3, 4, etc...I don't want to count the duplicates, but number them as they occur. Can anyone help me find a formula to do this? Thank you in advance!

For example:

[TABLE="width: 159"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]doe, john[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]doe, boy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]dole, bob[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]madison, billy[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]dole, bob[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]madison, billy[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]joel, bill[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]jefferson, tom[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]doe, john[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]madison, billy[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[chicagocomputerclasses]

Here you go

=COUNTIF(A$1:A1,A1)

 

[Jonmo1]

Assuming that table starts in A1

In B1, put
=COUNTIF(A$1:A1,A1)

And fill down.

 

[lwthomp80]

Worked great! Thank you!!

 

[Jonmo1]

You're welcome.