Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
All Tags
»
Ranges
(RSS)
Browse Site by Tags
Showing related tags and posts accross the entire site.
Sorry, but there are no more tags available to filter with.
Re: Forecasting using Trend Function Need to Update Each month with New Actuals
Not sure how your Trend functions are already built, but can you use a named range and then you just need to expand that or you could use a OFFSET(....COUNTA....) function in the named range to 'auto-expand' the range. A little like this http://www.contextures.com/xlNames01.html
Posted to
Functions and Formulas
(Forum)
by
Nick Hodge
on Mon, May 5 2008
Page 1 of 1 (1 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.