Recent Comments
A Very Short Article… on Is Hinchliffe’s Rule Tru… 
dougaj4 on Using LinEst() on data with… 
Chris on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Chris on Using LinEst() on data with… dougaj4 on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … 
Sunny on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … Sunny on Concrete ULS spreadsheet … Using Numba with Exc… on Two Timers 
masood bhatti on Deflections and Moments in Rec… Kapasitas Lateral Ti… on LatPile – Analysis of La… 
mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness…
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
