number alpha list w/duplications

[Deb]

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...

 

[Mike H]

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]

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.

 

[David Biddulph]

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

 

[Deb]

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