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

"Knox" wrote:

Thank you Lori, that was driving me crazy all day

"Lori" wrote:

maybe try this array-formula instead:

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

"Knox" wrote:

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