I have the formula "=TRANSPOSE(LINEST(C83:C142, B83:B142))" for find beta and alpha from my data. As the value of beta and alpha takes up two cells, when I want to drag down the formula, the next cells two cells become "=TRANSPOSE(LINEST(C85:C144, B85:B144))" but what i need is "=TRANSPOSE(LINEST(C84:C143, B84:B143))". Is there any method that could help ? Thanks very much
Bookmarks