Identify AND change duplicates

[erisaaka]

I've attached an excel file of what I need.

Basically, I need help figuring out a way that I can click on an entire column, identify all the duplicates and add _1, _2, _3, and so on after each duplicate.

For example, if the number 1234 shows up 4 times in column A I want to be able to click column A and through a series of functions change it to say 1234_1, 1234_2, 1234_3, 1234_4.

I hope that makes sense! Thanks any advance for the help.

[erisaaka]

I forgot to attach Book1.xlsx

[XOR LX]

Hi,

Perhaps you'd be satisfied with your desired results in a separate column?

For example, based on your attachment, in B2 and copy down:

=A2&"_"&COUNTIF(A$2:A2,A2)

Regards

[erisaaka]

That works! Thanks!

[arlu1201]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

[erisaaka]

Can you please explain what is happening in this formula? The absolute value on $2 is confusing me. It works but I just want to understand why it works.