var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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,
Last edited by PDIDDLE; 11-16-11 at 11:44.