| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find max value in column and return offset of that value | Excel Discussion (Misc queries) | |||
| Countif from an offset column | Excel Worksheet Functions | |||
| offset 1 row and return to first column | Excel Discussion (Misc queries) | |||
| ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1) | Excel Worksheet Functions | |||
| offset every nth column | Excel Worksheet Functions | |||
Linear Mode
