How do I assigned a same number to the duplicate names.

[Guest]

when I import data from excel sheet, there is a too many duplicate names in
the name field. so I 'd like to create a number field and try to assign a
same number to same to every duplicate names. How should I solve this
problem?

 

[Ken Snell [MVP]]

Your question is not clear. Do you want this:
A 1
B 2
A 1
A 1
C 3
B 2
C 3
D 4

or do you want this:
A 1
B 1
A 2
A 3
C `
B 2
C 2
D 1