Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    493
    Thanks
    82
    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 20:08.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,329
    Thanks
    3
    Thanked 218 Times in 201 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
    493
    Thanks
    82
    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
    493
    Thanks
    82
    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,919
    Thanks
    152
    Thanked 746 Times in 678 Posts
    How about using the Forecast function?

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

    Forecast1.png
    Last edited by Maudibe; 2014-11-05 at 21: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
  •