actually not a question, more like an Excel trick someone could use.
Formula to produce an array of numbers, starting from 1, repeating that number x times.
After that, repeating the next integer x times.
Until the maximum y is met. From then on, it repeats itself.
This description might be complicated, but English is not my native language. Feel free to add text to this thread to make this thread easier to find.
in cell B6, type =MOD(INT((ROW()-ROWS(B$1:B$5)-1)/B$2);B$3)+1 (some users have to substitute the ; with a ,)
copy this down to e.g. B999
in B2 typ a value (e.g. 3) this is x
in B3 typ a value (e.g. 5) this is y
see what happens and then fiddle with the values in B2 and/or B3
have fun.
Formula to produce an array of numbers, starting from 1, repeating that number x times.
After that, repeating the next integer x times.
Until the maximum y is met. From then on, it repeats itself.
This description might be complicated, but English is not my native language. Feel free to add text to this thread to make this thread easier to find.
in cell B6, type =MOD(INT((ROW()-ROWS(B$1:B$5)-1)/B$2);B$3)+1 (some users have to substitute the ; with a ,)
copy this down to e.g. B999
in B2 typ a value (e.g. 3) this is x
in B3 typ a value (e.g. 5) this is y
see what happens and then fiddle with the values in B2 and/or B3
have fun.
