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

COUNTIF not including something in both columns 2
Need a function to match unidentical strings 0
Setting column width in a table with a macro is not working 0
Separating a comma separated list 3
vlookup in different workbooks with dynamic ranges 6
If..The Statement to automatically format a name 9
Insert name and adress from a list in a word document 1
parsing a full name out into Last, First, Middle 2

Top