Here's my 10 most recent figures compound annual growth rate formula, excluding non numeric values, (It an array). Maybe this will help someone with the average annual growth rate formula. It's kind of cool as it keeps the sheet looking smart by returning a blank if it's an error.

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