I'm not sure you're going to get much help here. if you were to say that you have a numeric sequence and would like help predicting the next number in the series.
Then, there MIGHT be a solution. Because there may be a relationship between the numbers in the series: 10 20 30 40 50... the next numbers are 60 and 70. or 10 20 40 70 110.. the next number would be 160, then 210 So, a relationship exists between the numbers in the series. But there is no relationship between the numbers when they represent trends in sales. The trends are based on the goods sold, time of year, economy, and a myriad of other factors! I mean.. if you're talking about clothing: sales of winter clothes is affected by the season and severity. By simply asking for a numeric trend analysis, even if a numeric relationship is observed, it would just be a coincidence. Not an indicator of a trend... sorry... Paul > >From: neil johnson <neil.jh...@googlemail.com> >To: excel-macros@googlegroups.com >Sent: Tue, October 5, 2010 11:36:11 AM >Subject: $$Excel-Macros$$ Fwd: > > > > >Hi Everyone , > >I have rows of data with which I'd like to forecast the next 2 periods of >data for. What is the formula to do this. I'd like to do this in excel >all on one row as shown below: > >month Jan Feb March April May June July Aug Sep(current Month) >Next remaing month >------ --- --- --- --- --- --- --- --- --- ------------ >-------------- >Sales 10 20 30 10 50 60 75 80 ? > ? > > >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
