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: 504
Default Trending Function?

I'm trying to have a six month forcast of storage used on a server.

I have range D3:O3 as storage values assigned for 12 months
I have range D2:O2 as the date each of the storage values were pulled.

I would like to have a formula in cells p3,q3,r3,s3,t3,u3 that will give me
a forcast for 1 month out, 2 months etc.

Would I use the Trend formula for that?

Thanks,
Kevin Green
 
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 I display trending data in different colors (up=red) rmckay Excel Discussion (Misc queries) 1 November 5th 09 09:59 PM
Trending Methodology Jeff Excel Discussion (Misc queries) 1 August 17th 09 07:59 PM
polynomial trending Orion Charts and Charting in Excel 6 November 17th 08 05:22 PM
Trending data asim Excel Discussion (Misc queries) 0 July 6th 06 10:13 PM
help on excel reports for anaylsis and trending Terri Excel Worksheet Functions 0 May 4th 05 03:44 PM


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

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"