Forum Discussion

PaulGrant78's avatar
PaulGrant78
Copper Contributor
Jun 07, 2024

Set sequence possible?

Good day friends,   I am creating an excel sheet to document our PAT testing. What I need is the ability to go from, for example: A101-01-01 A101-01-02 A101-01-03 A101-01-04 then A101-02-0...
  • SergeiBaklan's avatar
    Jun 07, 2024

    PaulGrant78 

    That could be

    =LET( seq, SEQUENCE(100), "A101-"& TEXT(INT((seq-1)/4)+1, "00") & "-" & TEXT(MOD(seq-1,4)+1, "00") )

Resources