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
- Converting from global to local coordinates (and vice versa)
- Fitting high order polynomials
- Smart Indenter and Excel 2013
- Buckling of columns with varying cross section
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: functions returning references
Excel functions that return references and new functions
The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading