Average Annual Growth Rate that excludes non numeric values.

Hi,

I have rows that contain the past 20 years of figures. The last column (U), contains a formula that calculates the most recent 10 years Compound Annual Growth Rate, excluding any non numeric values.

I need a formula that can calculate the most recent 10 years Average Annual Growth Rate, excluding any non numeric values. (The most recent figures start on the right hand side). I can do the simple Average Annual Growth Rate when there's no gaps in the figures but I just can't work out the excluding any non numeric values in an over all formula.

Also, I've never posted a document in a forum before. Please let me know if I've posted safely. I had a look at it and I can't see any personal things but then again, I might be missing something others would see.

Thanks for any help/advice in advance.