HarleyBigDog
New Member
- Joined
- Sep 11, 2008
- Messages
- 5
I have looked over the forums for information on how to do this, and can not find anything. I have used conditional formatting to identify duplicates in my spreadsheet. I have a unique user ID, which combines the first and last name fields into one. However, in 10,000 there are a number of John Smiths, Joe Adams, etc. With smaller lists, we search manually, and then add a 1, 2, 3, etc to each duplicate to create a unique value for the User ID.
My question is:
Is there a way to check for duplicates, and then automatically add numbers to the duplicate values to make them unique? If so, how can this be done?
So that you will have this:
JohnSmith
JohnSmith2
JohnSmith3
JaneDoe
JaneDoe2
JohnAdams
JohnAdams2
JohnAdams3
JohnAdams4
I think I have done a good job in illustrating what I would like to be able to do, but if there is still something that is unclear, I will post whatever clarification is needed.
Thank you in advance for your help!!
My question is:
Is there a way to check for duplicates, and then automatically add numbers to the duplicate values to make them unique? If so, how can this be done?
So that you will have this:
JohnSmith
JohnSmith2
JohnSmith3
JaneDoe
JaneDoe2
JohnAdams
JohnAdams2
JohnAdams3
JohnAdams4
I think I have done a good job in illustrating what I would like to be able to do, but if there is still something that is unclear, I will post whatever clarification is needed.
Thank you in advance for your help!!