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...
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))