Set sequence possible?

[PaulGrant78]

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

[#2 · Accepted solution]

@PaulGrant78 

That could be

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

[#3]

You are a god amongst men sir.

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

[#4]

@PaulGrant78 , you are welcome

[#5]

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

[#6]

Thanks for answering, you made my day.

[#7]

@WyattGreen , you are welcome