Recent Comments
vgmendes on LinEstGap with non-linear… 
Stan on ALGLIB linear and polynomial f… 
dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder 
Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… 
GP on Weighted Least Squares Regress… 
Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update 
angelgalvanc on 3D Frame Update More on Numba | Newt… on Making Finite Element Analysis… dougaj4 on Writing Arrays to the workshee…
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
