Generating unique codes

Get new comments by email
You can cancel email alerts at anytime.
Comments (1)

Ami in Mumbai, India

38 months ago

Hi i have data like this:

a1 a2 a3 a4
ABC ABC xx zz
ABC xx mm mm
fg ui ok pl

I want to give them unique codes like :
Code for column a1 Code1
ABC C-1
ABC C-1
fg C-2
then column a2 Code2
ABC C-1
xx C-3
ui C-4
then column a3 Code3
xx C-3
mm C-5
ok C-6
then column a4 Code4
zz C-7
mm C-5
pl C-8
I can add these Code1 , Code2 etc columns to update.
PLease provide solutions

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.