T
thijze
I would like to use the LINEST function on data that is not located in
one single row or column. The data that have to be correlated are
scattered along the worksheet and I would like to select them
manually. How can I do this. If I try
=LINEST((E72;F72;G72);(E75;F75;G75),1,1) or =LINEST({E72;F72;G72};
{E75;F75;G75},1,1) an error occurs. How can I input an array of
nonadjacent cells in this function.
thx
one single row or column. The data that have to be correlated are
scattered along the worksheet and I would like to select them
manually. How can I do this. If I try
=LINEST((E72;F72;G72);(E75;F75;G75),1,1) or =LINEST({E72;F72;G72};
{E75;F75;G75},1,1) an error occurs. How can I input an array of
nonadjacent cells in this function.
thx