Average Annual Growth Rate that excludes non numeric values.

I hadn't a clue what was going on... So I had to dissect your first formula, to understand what you were doing. For what it's worth, it could be simplified a bit (array entered):

=IFERROR((LOOKUP(10^10,A1:T1)/INDEX(A1:T1,LARGE(IF(A1:T1<>"-",COLUMN(A1:T1)),10)))^(1/(10-1))-1,"")

now to your problem....

What formula have you used for annual growth rates ??? (spot the analytical chemist who knows stuff-all about financial functions)...

Hi Glen,

yes that new formula tidied things up a bit. It also looks better with a blank cell rather an error return, thanks for that.

Below is my annual growth rates formula. Oh and here's a link to the page I got it from, http://www.investopedia.com/terms/a/aagr.asp

=SUM((L1/K1-1)+(M1/L1-1)+(N1/M1-1)+(O1/N1-1)+(P1/O1-1)+(Q1/P1-1)+(R1/Q1-1)+(S1/R1-1)+(T1/S1-1))/9

My starting point is the 10th year so I can only divide by 9.

Thanks.

Sorry Glen, this is the formula for annual growth rates.

=SUM((L1/K1)-1+(M1/L1)-1+(N1/M1)-1+(O1/N1)-1+(P1/O1)-1+(Q1/P1)-1+(R1/Q1)-1+(S1/R1)-1+(T1/S1)-1)/9

Edit,

I think that does the same thing. I'm on a real roll today.

In fact I know it does the same thing. My calculation page is a mess. One of my N1 references was a N51. I've corected it now. Just use the first formula if you think is better.