ExcelBanter - Insert column with offset

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Insert column with offset (https://www.excelbanter.com/excel-discussion-misc-queries/138905-insert-column-offset.html)

phlyman

Insert column with offset

I have an OFFSET set up which is (NAME,0,2). When I insert a new column I
expected the OFFSET to automatically change to (NAME,0,3) but it does not.
Any ideas why?

T. Valko

Insert column with offset

Try it like this:

=OFFSET(NAME,0,COLUMN(B1))

Biff

"phlyman" wrote in message
...
I have an OFFSET set up which is (NAME,0,2). When I insert a new column I
expected the OFFSET to automatically change to (NAME,0,3) but it does not.
Any ideas why?

phlyman

Insert column with offset

Thank you!

"T. Valko" wrote:

Try it like this:

=OFFSET(NAME,0,COLUMN(B1))

Biff

"phlyman" wrote in message
...
I have an OFFSET set up which is (NAME,0,2). When I insert a new column I
expected the OFFSET to automatically change to (NAME,0,3) but it does not.
Any ideas why?

T. Valko

Insert column with offset

You're welcome!

Biff

"phlyman" wrote in message
...
Thank you!

"T. Valko" wrote:

Try it like this:

=OFFSET(NAME,0,COLUMN(B1))

Biff

"phlyman" wrote in message
...
I have an OFFSET set up which is (NAME,0,2). When I insert a new column
I
expected the OFFSET to automatically change to (NAME,0,3) but it does
not.
Any ideas why?

All times are GMT +1. The time now is 10:37 PM.