Is there a way to copy formulas following a pattern established within the formula?
Example:
A1 = C1
A2 = C4
A3= C7
Is there a way to highlight A1-A3 and drag down and have the formula follow the same sequence for C?
Is there a way to copy formulas following a pattern established within the formula?
Example:
A1 = C1
A2 = C4
A3= C7
Is there a way to highlight A1-A3 and drag down and have the formula follow the same sequence for C?
You may do it in these steps.
=C1
to A1, =C4
to A2.Data
▸Text to Columns...
to convert the data to formulas (just accepting defaults is OK), or use this FAQ.Alternatively, you could change your formula to include the information about relative position of the target cell - something like
=OFFSET($C$1;(ROW()-1)*3;0)