Hi,

I'm not sure if this is possible but I need to make a macro that searches a column for duplicates. If it finds a duplicate I need to it to make it unique by adding a .1 at the end. I would also want it to continue to add unique identifiers if there are say 5 duplicates of the same field.

For example it would find 5185 in the column five times. It would then proceed to change the duplicates to 5185.1 - 5185.2 - 5186.3 - 5185.4 - 5185.5

Is this possible to do?

Thanks!