Find duplicate values and assign unique ID
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?
Client Field New Unique Id Field
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