Forum Discussion

RBearden's avatar
RBearden
Copper Contributor
May 24, 2022

Sequencing

Need some help with sequencing. Below is what I am trying to do. I know the basic formula, but I am having issues getting 2nd number to increment up after a count of 5. I am currently changing the second number manually.

="RACK-"&"30-"&"1-"&SEQUENCE(5,1,1,1)   

="RACK-"&"30-"&"2-"&SEQUENCE(5,1,1,1)   

="RACK-"&"30-"&"3-"&SEQUENCE(5,1,1,1)

RACK-30-1-1
RACK-30-1-2
RACK-30-1-3
RACK-30-1-4
RACK-30-1-5
RACK-30-2-1
RACK-30-2-2
RACK-30-2-3
RACK-30-2-4
RACK-30-2-5
RACK-30-3-1
RACK-30-3-2
RACK-30-3-3
RACK-30-3-4
RACK-30-3-5
So on and so forth
excel
Formulas and Functions

2 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    May 24, 2022

    RBearden 

    If you're rolling with Insider, you might try:

    =LET(x,SEQUENCE(5,SEQUENCE(,5),SEQUENCE(5),0),"RACK-30-"&TOCOL(x)&"-"&TOCOL(x,,1))

  • mtarler's avatar
    mtarler
    Silver Contributor
    May 24, 2022

    Try this
    ="RACK-"&"30-"&QUOTIENT(SEQUENCE(N,1,0),5)+1&"-"&MOD(SEQUENCE(N,1,0),5)+1

    where "N" is the total number of rows you want filled

Resources