Combining 2 cells and if the result is duplicate add hyphen & running number

[AnusornKh]

Hi all,

I wonder if we can automatically add a hyphen and running number

I have a lot of data

Column A - Starting Code - Default "DFP"

Column B - Ending Code - These are numbers and some of them are duplicates

In Column C - I am going to combine A + B = But because B has duplicates the results in C will also end up having duplicates

I want another column Column D - to check duplicates and add a hyphen and running number (-1, -2, -3) if duplicates are found. Is it possible to do this in Excel?

[#2 · Accepted solution]

@AnusornKh 

=IF(COUNTIF($C$2:$C$7,C2)=1,"",C2&"-"&COUNTIF($C$2:C2,C2))

This formula returns the intended result in my sheet.

 

[#3]

Thank you!!

Worked like a charm