Hi,
I found this offset formula in a different post
offset(A1,1,0,counta(A:A)-1,1),
I think this is kind of what I am looking for, but I'm not positive, but I
would need it for multiple columns.

Essentially i need the following, (x being a dynamic row number being
determined by the last cell to have a value in the range).

=LINEST(B2:Bx,C2:Fx,TRUE,TRUE)

Any help is greatly appreciated, Thanks!

Best,

--
RJ