| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert column : lose inclusion in functions
I have found in Excel 2007 on occasions,when I add a column I lose the
inclusion within a sum function, even 'though I have inserted the new column. I have now discovered a similar situation in a =vlookup function, which now requires me to adjust the col-index-num, wheras I am accustomed to this being automatic. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert column : lose inclusion in functions
AFAIK, the column index never updated automatically. I just tested with Excel2003 and it doesn't update there. The range of the
lookup table will be updated, but not the column index -- Kind regards, Niek Otten Microsoft MVP - Excel "Hood" wrote in message ... |I have found in Excel 2007 on occasions,when I add a column I lose the | inclusion within a sum function, even 'though I have inserted the new column. | | I have now discovered a similar situation in a =vlookup function, which now | requires me to adjust the col-index-num, wheras I am accustomed to this being | automatic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do we make Inclusion-Exclusion Principles on Excel? | Excel Worksheet Functions | |||
| inserting columns inclusion in formula | Excel Worksheet Functions | |||
| Automatic Inclusion of Comments on Chart Data Points?? | Excel Discussion (Misc queries) | |||
| It is some functions who insert rows? | Excel Worksheet Functions | |||
| Insert Functions | Excel Discussion (Misc queries) | |||
Linear Mode
