Forum Discussion
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-01
A101-02-02
A101-02-03
A101-02-04
etc etc without having to type EVERY single one.
Can any of you big brains/experts help?
Many thanks in advance,
Paul
That could be
=LET( seq, SEQUENCE(100), "A101-"& TEXT(INT((seq-1)/4)+1, "00") & "-" & TEXT(MOD(seq-1,4)+1, "00") )
That could be
=LET( seq, SEQUENCE(100), "A101-"& TEXT(INT((seq-1)/4)+1, "00") & "-" & TEXT(MOD(seq-1,4)+1, "00") )- You are a god amongst men sir.
Thank you so much, you've saved me SO much time.PaulGrant78 , you are welcome
Thanks for answering, you made my day.
WyattGreen , you are welcome
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")))
