Would anyone know the formula when copying down rows from row 1 it does the following:
- where x can any positive number, e.g. if x = 4, the following from row 1 down would be
1
2
3
4
1
2
3
1
2
1
""
""
etc.
e.g. if x = 3
1
2
3
1
2
1
""
""
etc.
I suspect you would need the function row() and a cell reference to x, but the mathematical formula eludes me.
Thanks!
- where x can any positive number, e.g. if x = 4, the following from row 1 down would be
1
2
3
4
1
2
3
1
2
1
""
""
etc.
e.g. if x = 3
1
2
3
1
2
1
""
""
etc.
I suspect you would need the function row() and a cell reference to x, but the mathematical formula eludes me.
Thanks!