| 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 |
| 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) | |||
Threaded Mode
