If I want to copy a formula every 5th column, and still make the formulas count +1 column. How is it done?
For example, this is how it is displayed if i copy them now:
A4=B2/B3
F4=G2/G3
J4=K2/K3
But i want them like this:
A4=B2/B3
F4=C2/C3
J4=D2/D3
So that the cells in the formula is +1column, even if the formula moves +5columns. Is this possible? How?
I have 800 formulas to do it with so i don't want to do it manually
Bookmarks