Smartly auto-increment called cells
When I try to increment called rows or columns in a sequence that skips one or sevral numbers such as:
=A1
=A3
=A5
=A7
=A9
by providing the first 2 cells (e.g. =A1 and =A3), it doesn't work.
Instead I get:
=A1
=A3
=A3
=A5
=A5
=A7
=A7
=A9
=A9
and it gets weirder if I try to help it further by providing the first 3 cells:
=A1
=A3
=A5
=A4
=A6
=A8
=A7
=A9
=A11
Can I fix this ?
No - because you want A2=A1+2; A3=A2+2, ... so you make useless use of ROW() function, which btw. works as expected. In your "2 cells" example:
and these two rules are repeated if you drag down. Same applies for your "3 cells" example.
You had some reasonable formulas there (
=ROW(A1)
,=ROW(A3)
); now you changed that to something that just couldn't work if you put that into A1 and A2: putting there=A1
and=A3
would create cycles.No because I actually want to increment the called cells, so I edited my post to better fit my problem. Sorry for my lack of clarity.
Boah - this should have been mentioned that you want increment cell references and not cell values.