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