If I drag a formula to the right it adapts the column letter in the formula from A to column B, which is standard.
However, if I drag the formula to the right I want Excel to skip a column each time.
In other words:
=A1 ; = B1 ; = C1
Should be
=A1 ; = C1 ; = E1 etc...
can this be done easily
many thanks
shaun
[Solved] Skip columns when dragging
[Solved] Skip columns when dragging
Last edited by dwarfer1 on Wed Mar 14, 2018 10:42 am, edited 1 time in total.
OpenOffice 3.3.0 on Windows Vista
Re: skip columns when dragging
With the following formula in A2, dragging to the right will skip columns
That is, the formula in B2 will return the value of C1 and the formula in C2 will return the value of E1.
Code: Select all
=OFFSET(A2;COLUMN() - 1)OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Skip columns when dragging
Thanks used a variation of this and a helper row.
OpenOffice 3.3.0 on Windows Vista