SOLVED

Excel numbering

Copper Contributor

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    DL-0201

and so forth, how can I automate displaying the numbers in DL based on the associated HL

1 Reply
best response confirmed by maisag1982 (Copper Contributor)
Solution

@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")
1 best response

Accepted Solutions
best response confirmed by maisag1982 (Copper Contributor)
Solution

@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")

View solution in original post