Hi,
I have in column A of the attached file some product names and in column B the sales growth rates for the products over a couple of periods.
In F2 I have used the PRODUCT function to calculate the compound growth rate of AAA, and the same is calculated for BBB in F3.
Can someone please suggest how I make the PRODUCT formula calculate the compound growth rate for a given product (AAA etc), so I don’t have to select the range over which the compound growth is calculated for each product.
Thanks!
Bookmarks