User profile for user: ianfromlos angeles
ianfromlos angeles Author
User level: Level 1
4 points

Make the OFFSET column adjustment always reference a specific column.

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?

Posted on Mar 2, 2025 11:58 AM

Reply
1 reply
Sort By: 
User profile for user: Badunit
Badunit
User level: Level 7
29,008 points

Mar 2, 2025 3:42 PM in response to ianfromlos angeles

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)

Reply

Make the OFFSET column adjustment always reference a specific column.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up