| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that will skip blanks cells | Excel Discussion (Misc queries) | |||
| paste formula and skip blanks | Excel Discussion (Misc queries) | |||
| skip blanks | Excel Worksheet Functions | |||
| Skip Over Blanks | Excel Discussion (Misc queries) | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Linear Mode
