August 6, 2020
Hey to all Excel Fans out there,
I have following issue:
I would like to use this formula FORECAST.ETS.CONFINT() in order to get a lower and upper boundary for a certain forecast.
I'd like to consider as much as data as possible, is there any way to increase the range of the values within the formula?
For example =FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])
=FORECAST.ETS.CONFINT(target_date, table1!$B$4:$B$45$ & [File2.xlsx]table2!$A$1:$A$35, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])
Likewise I need to increase the range of the timeline.
Plan B would be another file where I combine the data via power query and then use this function with one range.
Hope someone has another idea 🙂
P.S. I am using Excel 365 64bit on a PC.