AnsweredAssumed Answered

Find duplicate values and assign unique ID

Question asked by kentanderson on Feb 14, 2014
Latest reply on Feb 14, 2014 by philmodjunk

Title

Find duplicate values and assign unique ID

Post

     I have thousands of records, that have a lot of the same data.  I would like to find all duplicate data in a field and assign it a unique id in another field.  Is this possible?

     Example 

     Client Field         New Unique Id Field

     apple                   1

     apple                   1

     apple                   1

     Banana               2

     Banana               2

     Orange                3

     To complicate things I need to assign a unique id also to those that are not duplicate like Orange only appears in one record

     Thank You in advance   If this is possible it will solve all my problems

Outcomes