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

K

korman

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?
 
K

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
 
Top