Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Taming Symbols in Excel
- Frame Analysis with Excel 1 - Single beam
- Downloads by category
Recent Comments
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