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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating a comma separated list 3
COUNTIF not including something in both columns 2
Need formula that Counts items matching criteria using two columns 4
vlookup in different workbooks with dynamic ranges 6
How do I copy cells from one worksheet to another based on values 2
If..The Statement to automatically format a name 9
Formula for names 6
assigning a unique value 27

Back
Top