Oct 20 2022 12:34 PM
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
Oct 20 2022 01:14 PM
SolutionHello, 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")
Oct 20 2022 01:14 PM
SolutionHello, 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")