Forum Discussion

AnusornKh's avatar
AnusornKh
Copper Contributor
Oct 29, 2023
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...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Oct 30, 2023

    AnusornKh 

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

    This formula returns the intended result in my sheet.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 30, 2023

AnusornKh 

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

This formula returns the intended result in my sheet.

 

  • AnusornKh's avatar
    AnusornKh
    Copper Contributor
    Nov 05, 2023
    Thank you!!

    Worked like a charm