Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- RCInteract and RC Design Functions 7.03
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 5: Frame Analysis
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
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