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