Hi Mr Excel Forum,
I'm a new member and hope that you kind souls are able to help me with this hopefully easy question.
I'm trying to create a statistical forecasting function using the FORECAST.LINEAR function, and the idea is to work with high volumes of data so I believe the exact cell ranges of "known_ys" and "known_xs" needs to be looked up in some way in a big table instead of as is presented in below snippet.
As the input to "known_ys" is a range of cells, I have tried to replace the C9:F9, i.e. the "known_ys" with a combination of CELL/INDEX/MATCH to get the row as well as the start and end column of the range, but I don't get it to work for the FORECAST.LINEAR function by just replacing "C9:F9" with the output in cell G18 and H18. The idea is to do the same for the known_xs once I found a solution.
Formulas used in snippet:
G18: =CELL("address";(INDEX($B$6:$F$13;MATCH($B15;$B$6:$B$13;0);2)))
H18: =CELL("address";(INDEX($B$6:$F$13;MATCH($B15;$B$6:$B$13;0);5)))
Anyone can help me? I suppose I may be on the wrong track... See below for a snippet explaining the situation.
Kind regards,
MrCool888
I'm a new member and hope that you kind souls are able to help me with this hopefully easy question.
I'm trying to create a statistical forecasting function using the FORECAST.LINEAR function, and the idea is to work with high volumes of data so I believe the exact cell ranges of "known_ys" and "known_xs" needs to be looked up in some way in a big table instead of as is presented in below snippet.
As the input to "known_ys" is a range of cells, I have tried to replace the C9:F9, i.e. the "known_ys" with a combination of CELL/INDEX/MATCH to get the row as well as the start and end column of the range, but I don't get it to work for the FORECAST.LINEAR function by just replacing "C9:F9" with the output in cell G18 and H18. The idea is to do the same for the known_xs once I found a solution.
Formulas used in snippet:
G18: =CELL("address";(INDEX($B$6:$F$13;MATCH($B15;$B$6:$B$13;0);2)))
H18: =CELL("address";(INDEX($B$6:$F$13;MATCH($B15;$B$6:$B$13;0);5)))
Anyone can help me? I suppose I may be on the wrong track... See below for a snippet explaining the situation.
Kind regards,
MrCool888