Combining Data Series of two different files via formula (no powerquery)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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.