In B1 enter 1
In B2 enter:

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

and copy down
--
Gary''s Student - gsnu200748


"Access Joe" wrote:

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