LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do we make Inclusion-Exclusion Principles on Excel? wewetts Excel Worksheet Functions 0 June 6th 07 01:44 PM
inserting columns inclusion in formula srinivasan Excel Worksheet Functions 3 August 29th 06 02:21 PM
Automatic Inclusion of Comments on Chart Data Points?? Mike P. from KC Excel Discussion (Misc queries) 0 April 6th 06 04:33 PM
It is some functions who insert rows? Cineva Excel Worksheet Functions 3 November 19th 05 09:46 PM
Insert Functions reset Excel Discussion (Misc queries) 0 December 20th 04 09:26 PM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"