Shukla it's ok as I now have two formulas for compound growth rates. It's the average annual growth rate, excluding non numeric values, that I'm after now.