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:
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:
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