Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Daily Download 3: ULS design of reinforced concrete sections
- Linking Excel to C - 2
- Continuous Beams With Spring Supports by Macaulay’s Method
- Buckling of columns with varying cross section
Recent Comments
Tag Archives: Selected average function
SelectAv Function
Suppose you have a spreadsheet range containing numerical data, and would like to find the average for a number of the most recent values, ignoring the highest (and/or lowest) values from the selected set. If you like using long array … Continue reading