Can you change the known X's range to Row reference of known Y's?
I am trying to eleminate columnA. Thanks
=INDEX(LINEST(B1:B5,A1:A5),1)
=INDEX(LINEST(B13:B17,A13:A17),1)