I am trying to create an offset formula that always references the 1st Column instead of a specific number of columns.
For example I am trying to find a way to write a formula that says:
OFFSET (base), 0 rows, and then instead of referencing -2 or -3 columns over, always reference the first column.
This would allow me to add columns in between the base and the reference column without breaking the formula.
Any advice?
Maybe something similar to this (written for cell E4)
=OFFSET(E4,0,1−COLUMN(),1,1)
A column offset of 1-COLUMN() will put it in the first column. I assume you want it to return more than one row and/or column of data but I used 1 and 1 in the formula.
Or if you want the base to be some other cell, use that cell as the base and also use it in the COLUMN function.
=OFFSET(C3,0,1−COLUMN(C3),1,1)
Maybe something similar to this (written for cell E4)
=OFFSET(E4,0,1−COLUMN(),1,1)
A column offset of 1-COLUMN() will put it in the first column. I assume you want it to return more than one row and/or column of data but I used 1 and 1 in the formula.
Or if you want the base to be some other cell, use that cell as the base and also use it in the COLUMN function.
=OFFSET(C3,0,1−COLUMN(C3),1,1)
Make the OFFSET column adjustment always reference a specific column.
