Excel Macro Create Squence Numbers for Duplicate Names

hi,

I need help to add sequence numbers for duplicate names

For Example:

Column A   Column B
Thomas             0
Thomas             1
Larry                  0
Larry                  1
Larry                  2


I have a large excel file that has multiple name

Either a formula or VBscript would work, but I don't know how to start it
thomasm1948Asked:
Who is Participating?
 
regmigrantConnect With a Mentor Commented:
if list starts in A1

put =COUNTIF($A$1:A1,A1)-1 in column b and copy down
0
 
thomasm1948Author Commented:
Excellent, Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.