Forum Discussion
Solved
Sequencing with Duplicate Numbers and Alternating Text
I'm creating sequences with a static numbered prefix, 2 repeated numbers that must sequence with an alternating A/B pattern and cannot figure out the proper coding for it. Any help would be appreciat...
nickjrusso12 With a modern version of Excel, you could try either of the following:
=TOCOL(19&TEXT(SEQUENCE(999),"-000")&{"A","B"})-OR-
=TOCOL(TEXT(SEQUENCE(999,,19001),"00-000")&{"A","B"})If {"A","B"} doesn't work out for you, try using HSTACK("A","B") instead.
nickjrusso12 With a modern version of Excel, you could try either of the following:
=TOCOL(19&TEXT(SEQUENCE(999),"-000")&{"A","B"})
-OR-
=TOCOL(TEXT(SEQUENCE(999,,19001),"00-000")&{"A","B"})
If {"A","B"} doesn't work out for you, try using HSTACK("A","B") instead.