Forum Discussion

maisag1982's avatar
maisag1982
Copper Contributor
Oct 20, 2022
Solved

Excel numbering

I have two columns in the sheet, the first represents HL, the second represents DL Each HL has many DLs associated, and this is how the numbering goes HL-01    DL-0101 HL-01    DL-0102 HL-02    D...
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Oct 20, 2022

    maisag1982 

    Hello, I hope I have understood your request correctly. Please try the following formula. It is set up so that the entries HL-01 in cell A1 start. Please adjust if necessary. Enter the formula in the column next to the HL column and copy it down.

     

    ="DL-"&RIGHT(A1,2)&TEXT(COUNTIF(A$1:A1,A1),"00")
dscheikey's avatar
dscheikey
Bronze Contributor
Oct 20, 2022

maisag1982 

Hello, I hope I have understood your request correctly. Please try the following formula. It is set up so that the entries HL-01 in cell A1 start. Please adjust if necessary. Enter the formula in the column next to the HL column and copy it down.

 

="DL-"&RIGHT(A1,2)&TEXT(COUNTIF(A$1:A1,A1),"00")

Resources