Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Biaxial bending update
- Smart Indenter and Excel 2013
- Converting from global to local coordinates (and vice versa)
- Fitting high order polynomials
- Buckling of columns with varying cross section
Recent Comments
Tag Archives: 3D range
Extracting data from a 3D range
I recently needed to extract data from a series of tables on separate worksheets, into a form suitable for plotting on an XY graph. In Lotus 123 this would be a piece of cake, since the Lotus @INDEX function has … Continue reading