vicktor schausberger
Member
Hello.
I would like to be able to control the range inside the coefficient trendline from an input box, I don't figure out how.
EXP(INDEX(LINEST(LN(B3:B21),LN($A$3:$A$21),,),1,2))
the range B3:B21 and the range A3:A21 how is possible from an input box change for any range I want, a little sniped code as example would be nice.
Thank you for reading this post.
Have a nice weekend.
I would like to be able to control the range inside the coefficient trendline from an input box, I don't figure out how.
EXP(INDEX(LINEST(LN(B3:B21),LN($A$3:$A$21),,),1,2))
the range B3:B21 and the range A3:A21 how is possible from an input box change for any range I want, a little sniped code as example would be nice.
Thank you for reading this post.
Have a nice weekend.