Forum Discussion
Solved
Combining 2 cells and if the result is duplicate add hyphen & running number
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...
=IF(COUNTIF($C$2:$C$7,C2)=1,"",C2&"-"&COUNTIF($C$2:C2,C2))This formula returns the intended result in my sheet.
=IF(COUNTIF($C$2:$C$7,C2)=1,"",C2&"-"&COUNTIF($C$2:C2,C2))This formula returns the intended result in my sheet.
- Thank you!!
Worked like a charm
