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
- Taming Symbols in Excel
- Frame Analysis with Excel 1 - Single beam
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Solving non-linear equations with two or more unknowns – 3
- Writing Arrays to the worksheet - VBA function
Recent Comments
Tag Archives: data in rows
Linestgap with data in rows
In response to a comment I have modified the LinestGap function to work on data arranged in rows. This function works the same as the Excel built in LinEst function, but ignores any data that has a blank cell in the … Continue reading
Posted in Excel, UDFs, VBA
Tagged data in rows, data with gaps, Excel, Linest function, LinEstGap, UDF, VBA
11 Comments