skip blanks in array formula (help!)

[Knox]

I tried using the following formula to find exponential growth. Some of the
data has blanks so I want to ignore those cells. This doesn't seem to work,
should I write a macro? thanx!

{=GROWTH(IF(A2:Z2<>"",A2:Z2,""),IF(A2:Z2<>"",A1:Z1,""),2032)}

2007 2006 2005 2004 2003 2002 2001 etc
4,260 4,250 4,540 4,560 4,550 3,890 etc
4,910 3,450 etc
5,930 7,160 6,010 5,160 4,150 4,520 etc

 

[Barb Reinhardt]

I'm not familiar with this function, but I wonder if part of your problem is
that you have 2032 instead of an array of the same length as A2:Z2.

 

[Lori]

maybe try this array-formula instead:

=EXP(FORECAST(2003,IF(A2:Z2<>"",LN(A2:Z2)),IF(A2:Z2<>"",A1:Z1)))

 

[Knox]

Thank you Lori, that was driving me crazy all day

 

[Lori]

Glad it worked for you, i had a similar problem myself a while ago