With names in column A, put the starting number in B1 and in B2 enter this
formula and pull down.

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

You can then copy paste special values for the numbered column to get
rid of the formulas.

HTH
Regards,
Howard

"Michelle" wrote in message
...
Hello,

I am new to Excel. I need help assigning numbers to a group of names. I
have 2500 names to assign...don't really want to do it manually!

Example

# Name
100 John Smith
100 John Smith
100 John Smith
101 Adam Suken
101 Adam Suken
101 Adam Suken

and so on....

Thanks!