skip blanks in array formula (help!)
 

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

skip blanks in array formula (help!)
 

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.
--
HTH,
Barb Reinhardt



"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

skip blanks in array formula (help!)
 

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

skip blanks in array formula (help!)
 

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

skip blanks in array formula (help!)
 

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