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

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!
 
L

L. Howard Kittle

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
If..The Statement to automatically format a name 9
parsing a full name out into Last, First, Middle 2
vlookup in different workbooks with dynamic ranges 6
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
See if a range of cells contains certain text to return the value 3
Merge multiple records in a field, based on criteria? 2

Top