number alpha list w/duplications

  • Thread starter Thread starter Deb
  • Start date Start date
D

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