Forum Discussion
PaulGrant78
Jun 07, 2024Copper Contributor
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...
- Jun 07, 2024
That could be
=LET( seq, SEQUENCE(100), "A101-"& TEXT(INT((seq-1)/4)+1, "00") & "-" & TEXT(MOD(seq-1,4)+1, "00") )
SergeiBaklan
Jun 07, 2024MVP
That could be
=LET( seq, SEQUENCE(100), "A101-"& TEXT(INT((seq-1)/4)+1, "00") & "-" & TEXT(MOD(seq-1,4)+1, "00") )
PaulGrant78
Jun 07, 2024Copper Contributor
You are a god amongst men sir.
Thank you so much, you've saved me SO much time.
Thank you so much, you've saved me SO much time.
- SergeiBaklanJun 07, 2024MVP
PaulGrant78 , you are welcome