Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Biaxial bending update
- Linestgap with data in rows
- Retrieving unique values from a range or array ...
- The history of the theory of beam bending - Part 3
- Using LINEST for non-linear curve fitting
- Automatic download of csv files
- Downloads by category
- Converting from global to local coordinates (and vice versa)
- The history of the theory of beam bending - Part 2
Recent Comments
Tag Archives: Linest function
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