Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Linestgap with data in rows
- Working with units in Excel - using VBA and Python
- Installing Python, Scipy and Pyxll
- Frame Analysis with Excel - 3, Continuous beam or frame
- Combining text files
- Reinforced Concrete Section Analysis - 3
- Using LINEST for non-linear curve fitting
- ALGLIB linear and polynomial fitting functions
- Extracting data from a 3D range
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