Uniquely number a set of names
 

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

Uniquely number a set of names
 

Assume the names start in A2, in B2 put

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

copy down


--


Regards,


Peo Sjoblom


"Access Joe" wrote in message
...
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

Uniquely number a set of names
 

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

Uniquely number a set of names
 

your solutions Gary & Peo worked GREAT. Thank you!

"Gary''s Student" wrote:

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