Uniquely number a set of names

[Access Joe]

Hey everyone,

Got a question that is sort of complex...so I'm hoping someone can help.

I have a list of names that I'd like to number. The list looks like this:

Column A
Joe
Pat
Joe
Joe
Pat
Terri
Terri
Joe
Terri

How I'd like to number these names is like so (the numbers can go into an
adjacent column):

Column A
Joe - 1
Pat - 1
Joe - 2
Joe - 3
Pat - 2
Terri - 1
Terri - 2
Joe - 4
Terri - 3
Pat - 3

See, each time the same name appears, it has to be numbered in sequence.
I'm imagining that a sort of this column would be the first thing I'd have to
do. But I can't figure out what type of formula would number these names in
that fashion.

Can anyone help? Thanks so much!

Joe

 

[Peo Sjoblom]

Assume the names start in A2, in B2 put

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

copy down


--


Regards,


Peo Sjoblom

 

[Gary''s Student]

In B1 enter 1
In B2 enter:

=COUNTIF($A$1:A2,A2)

and copy down

 

[Access Joe]

your solutions Gary & Peo worked GREAT. Thank you!