How do I assign a number to a name in another column?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

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