Average annual growth rate excluding non numeric values.

[AYS]

Thanks xld.

When I punched that into column U the figures looked a little out. I am a little burnt out though so maybe it's me.

I've now added a workbook so maybe that will help better than the copy/paste earlier.



Edit,

After a bit of a break xld, I now know what your formula does. It's giving me the average of a maximum 10 of the most recent figures. Not what I'm after but it will surely coming in handy for other things in the future. Thanks.