Tag Archives: blank values

Using LinEst() on data with gaps

A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps.  There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 36 Comments