LinkBack URL
About LinkBacks
Hi,
I use the following array function to compound a time series of monthly growth rates:
{=(PRODUCT(1+A1:A10/100)-1)*100}
Is it possible to replace this with one of the new Dynamic Array functions?
Thanks!
Hi,
I use the following array function to compound a time series of monthly growth rates:
{=(PRODUCT(1+A1:A10/100)-1)*100}
Is it possible to replace this with one of the new Dynamic Array functions?
Thanks!
could you upload a sample book with what you are trying to achieve ??
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hi,
Hopefully the attached example will illustrate my question.
In A1:A10 there are monthly sales growth numbers.
In A11 I've used the PRODUCT function to calculate the compound growth rate for the full 10 months.
My question is whether or not it's possible to replace the PRODUCT function, which requires CTRL-SHIFT-ENTER, with a new Dynamic Array function which doesn't?
Thanks!
below version is also array entered in order to make it dynamic in C1 type Value as 6 to calculate compound for 6 month if you change then it will calculate accordingly formula is in A11
Formula:
Please Login or Register to view this content.
Last edited by hemesh; 02-28-2020 at 05:12 PM.
array formula and not volatile
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks