Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    489
    Thanks
    78
    Thanked 2 Times in 1 Post

    Apply trend to selected cells

    Hi Loungers

    I need to apply a trend line to selected cells and project the trend line forward, I've worked that out, so the problem I'm having is how to restrict how far backwards the trend line goes (hope that makes sense)

    The attached sample should explain what I'm after.

    Any thoughts or suggestions would be appreciated.

    Regards
    Attached Files Attached Files
    Last edited by RetiredGeek; 2014-11-03 at 21:08.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,291
    Thanks
    3
    Thanked 198 Times in 184 Posts
    Like this?
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    489
    Thanks
    78
    Thanked 2 Times in 1 Post
    Thanks Rory - yes that's what I need

    Much appreciated

    Regards

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    489
    Thanks
    78
    Thanked 2 Times in 1 Post
    Thanks Rory - yes that's what I need

    Much appreciated

    Regards

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,733
    Thanks
    126
    Thanked 686 Times in 623 Posts
    How about using the Forecast function?

    =FORECAST(N3,$F4:Q4,$F3:Q3)

    Forecast1.png
    Last edited by Maudibe; 2014-11-05 at 22:58.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •