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
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- ULS Design Functions 2.13
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: Charles Williams
Working with dynamic arrays in Excel
Many of the VBA functions available here return results as arrays, which must be entered by selecting the desired output range, then pressing Ctrl-Shift-Enter (CSE). This can be inconvenient (or at least untidy) when the size of the output array varies. … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Charles Williams, dynamic arrays, Excel, Fast Excel, VBA, Wndows Insider
Leave a comment
Announcing Excel Summit South 2016!
After 2 years of organising, Charles Williams recently announced: EXTEND YOUR SKILLS This is a unique opportunity to: Learn from six of the world’s leading Excel MVP’s as they discuss the Excel topics most useful to you. Hear industry leading … Continue reading
Posted in Excel
Tagged Auckland, Charles Williams, Excel Conference, Excel Summit South, Melbourne, Sydney
1 Comment