Forum Discussion
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 se...
Try this
="RACK-"&"30-""IENT(SEQUENCE(N,1,0),5)+1&"-"&MOD(SEQUENCE(N,1,0),5)+1
where "N" is the total number of rows you want filled