Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: Trend Lines whilst ignoring empty cells

    Hi, I've been trying to solve this for a fairly large portion of my day so hopefully someone can help me with this.

    I've got a database with around 1700 rows of various numerical data.

    I'd like to use the TREND function to work out the trend and then eventually calculate the average divergence.

    My problem is that my data is varied and includes lots of blanks.

    Example data:

    A B C D E F G H
    1 2010 2009 2008 etc
    2 9 1 2 3 8 2 4 1
    3 - - - - 5 8 4 1
    4 4 7 5 - - - - -
    5 - - - 2 3 4 8 5

    What I've been trying to do is work out a way that means I don't have to complete this task manually for all rows. i.e. =TREND(E3:H3,E1:H1)

    Is there a way to do this across all columns while ignoring the empty cells, and referencing the correct x-axis range in order that I can apply it across my whole DB?

    Thanks for any help in advance,
    R
    Last edited by PDIDDLE; 11-16-11 at 12:44.

Posting Permissions

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