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

Copper Contributor

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 Replies
best response confirmed by AnusornKh (Copper Contributor)



This formula returns the intended result in my sheet.

running number.png 

Thank you!!

Worked like a charm