Forum Discussion

Copper Contributor

Jun 07, 2024

Solved

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...

excel

Formulas and Functions

SergeiBaklan

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

djclements

Bronze Contributor

Jun 07, 2024

PaulGrant78 Alternatively, you could try:

="A101-" & TOCOL(TEXT(SEQUENCE(99), "00") & TEXT(SEQUENCE(, 4), "-00"))

-OR-

=TOCOL(TEXT(SEQUENCE(99,, 10101), "A0-00") & TEXT(SEQUENCE(, 4), "-00"))

-OR-

=TOCOL(TEXT(SEQUENCE(10,, 101), "A0") & TOROW(TEXT(SEQUENCE(25), "-00") & TEXT(SEQUENCE(, 4), "-00")))