Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
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