Append unique number to duplicate cells
Posted on 2012-09-12
I have a Excel spreadsheet with item names in column C. I need to add a unique number suffix to each name for any duplicate names in column C. I can create additional columns to accomplish this. The new name should appear in column D.
The formula below works to append the total number of duplicates to the end of the name (if greater than one). However, I need this to append a unique number.
For example, what I need is: