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!
Name Growth Rate Name Total Growth AAA AAA E2: {=PRODUCT(1 + ($A$2:$A$11=$D2)*$B$2:$B$11) - 1} BBB BBB AAA CCC BBB DDD AAA BBB CCC CCC DDD DDD
The curly braces indicate that the formula must be confirmed with Ctrl+Shift+Enter instead of just Enter; you can't insert the braces manually.
Entia non sunt multiplicanda sine necessitate
Thanks very much.
Can someone please suggest how to achieve the results in columns D and E of my attachment using VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks