P
pncd2
This question is about specifying formula address ranges dynamically.
I am looking to do a series of Linest() regressions between one inde
with five years of data (row 10) and a large number of factors wit
variable data in terms of both start and end date (rows 20-165).
Linest() will fail if I use it for the constant five year (60 columns
data set because the factors are sparse. I need a way to set th
address range in Linest() as a formula or indirect address so that
can have other columns with the address of the first and last availabl
data.
This data is updated monthly so specifiying range sby hand for >10
factors is not practicable.
Does anyone have any experience with this type of range addressin
issue in Excel formulae or VBA?
Thank you
I am looking to do a series of Linest() regressions between one inde
with five years of data (row 10) and a large number of factors wit
variable data in terms of both start and end date (rows 20-165).
Linest() will fail if I use it for the constant five year (60 columns
data set because the factors are sparse. I need a way to set th
address range in Linest() as a formula or indirect address so that
can have other columns with the address of the first and last availabl
data.
This data is updated monthly so specifiying range sby hand for >10
factors is not practicable.
Does anyone have any experience with this type of range addressin
issue in Excel formulae or VBA?
Thank you