SOLVED

# Set sequence possible?

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

6 Replies
best response confirmed by PaulGrant78 (Copper Contributor)
Solution

# Re: Set sequence possible?

That could be

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

# Re: Set sequence possible?

You are a god amongst men sir.

Thank you so much, you've saved me SO much time.

# Re: Set sequence possible?

@PaulGrant78 , you are welcome

# Re: Set sequence possible?

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

# Re: Set sequence possible?

Thanks for answering, you made my day.

# Re: Set sequence possible?

@WyattGreen , you are welcome

1 best response

Accepted Solutions
best response confirmed by PaulGrant78 (Copper Contributor)
Solution

# Re: Set sequence possible?

That could be

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