Forum Discussion
Trouble with nested SEQUENCEs
I'm trying to create an automatic musical bar-numbering system. I'm wanting, for a set number of rows, to count 4 subdivisions and 4 beats per bar. So, for example: 1.1.1 1.1.2 1.1.3 1.1.4 1.2.1...
Andrew_Patterson Let's say the sequence starts in A1, then the formula below will do what you described.
=TEXTJOIN(".",,INT((ROW()-1)/16+1),INT(MOD(ROW()-1,16)/4+1),MOD(ROW()-1,4)+1)See attached, column A. It's dynamically linked to the row number through the ROW() function. If you don't want that you could base it on a SEQUENCE as shown in Columns F:G
- Thanks so much for this - I'll use it in the interim - I was hoping to use the SEQUENCE function so I could set up an array and refer to other cells for altering parameters (different number of bars, different number of beats per bar, etc.).
