number alpha list w/duplications
 

I have a list of 1400 names/entries with many names listed two/three times.
I need to assign one number to each person (skipping the duplications). This
is a UIL list where each child is entered in several events therefore the
duplications. Each child needs to have one id number assigned to him/her.
Any ideas ? thanks...

number alpha list w/duplications
 

If the names are in a column then select them and any associated columns and
sort by your names and duplicates should come together

Then put a 1 in a helper column alongside the top name. We will assume this
is in B1. Put this in B2 and drag down for the length of your names

=IF(A2=A1,B1,B1+1)

Mike

"Deb" wrote:

I have a list of 1400 names/entries with many names listed two/three times.
I need to assign one number to each person (skipping the duplications). This
is a UIL list where each child is entered in several events therefore the
duplications. Each child needs to have one id number assigned to him/her.
Any ideas ? thanks...

number alpha list w/duplications
 

thanks - I almost got it, here is a little more info for you and I know you
can completly solve for me. Last name is in column B, First name is in
column C and I'll use column G for my helper.

"Mike H" wrote:

If the names are in a column then select them and any associated columns and
sort by your names and duplicates should come together

Then put a 1 in a helper column alongside the top name. We will assume this
is in B1. Put this in B2 and drag down for the length of your names

=IF(A2=A1,B1,B1+1)

Mike

"Deb" wrote:

I have a list of 1400 names/entries with many names listed two/three times.
I need to assign one number to each person (skipping the duplications). This
is a UIL list where each child is entered in several events therefore the
duplications. Each child needs to have one id number assigned to him/her.
Any ideas ? thanks...

number alpha list w/duplications
 

So if you put 1 in G1, the formula in G2 would be
=IF(AND(B2=B1,C2=C1),G1,G1+1)
--
David Biddulph

"Deb" wrote in message
...
thanks - I almost got it, here is a little more info for you and I know
you
can completly solve for me. Last name is in column B, First name is in
column C and I'll use column G for my helper.

"Mike H" wrote:

If the names are in a column then select them and any associated columns
and
sort by your names and duplicates should come together

Then put a 1 in a helper column alongside the top name. We will assume
this
is in B1. Put this in B2 and drag down for the length of your names

=IF(A2=A1,B1,B1+1)

Mike

"Deb" wrote:

I have a list of 1400 names/entries with many names listed two/three
times.
I need to assign one number to each person (skipping the duplications).
This
is a UIL list where each child is entered in several events therefore
the
duplications. Each child needs to have one id number assigned to
him/her.
Any ideas ? thanks...

number alpha list w/duplications
 

PERFECT - THANKS !! I just wasn't sure about the AND or where to place it.

"David Biddulph" wrote:

So if you put 1 in G1, the formula in G2 would be
=IF(AND(B2=B1,C2=C1),G1,G1+1)
--
David Biddulph

"Deb" wrote in message
...
thanks - I almost got it, here is a little more info for you and I know
you
can completly solve for me. Last name is in column B, First name is in
column C and I'll use column G for my helper.

"Mike H" wrote:

If the names are in a column then select them and any associated columns
and
sort by your names and duplicates should come together

Then put a 1 in a helper column alongside the top name. We will assume
this
is in B1. Put this in B2 and drag down for the length of your names

=IF(A2=A1,B1,B1+1)

Mike

"Deb" wrote:

I have a list of 1400 names/entries with many names listed two/three
times.
I need to assign one number to each person (skipping the duplications).
This
is a UIL list where each child is entered in several events therefore
the
duplications. Each child needs to have one id number assigned to
him/her.
Any ideas ? thanks...