Calculating compound growth rate using VBA

Hi,

I have data arranged as shown in columns A and B of the attached file.

I’ve tried without success to write code that will work through columns A and B, and then put a single instance of each name in column D (from D2 onwards) and in column E the compounded rate of growth (as calculated, for example, in E2) for each name.

Can someone please suggest code that will accomplish this.

Thanks!