Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Deflections and Moments in Rectangular Plates
- Using Goal Seek on Multiple Cells
- Downloads by category
- Retrieving unique values from a range or array ...
- Downloads
Recent Comments
Tag Archives: ignore errors
Max, Min, and Aggregate
Recently I needed to find the maximum and minimum of a range of values including some #N/A values. Searching found a variety of solutions, of which the simplest (that works in all versions) seems to be: =MAX(IF(ISNUMBER(datarange),datarange)) =MIN(IF(ISNUMBER(datarange),datarange)) The function … Continue reading