Author Archives: dougaj4

More on Sums

Posted on 18/12/2015 by dougaj4

My post from last week, on using the Aggregate function to find the maximum and minimum of a range ignoring errors, was linked in the Contextures Blog’s weekly roundup, which also linked to the Contextures page of Sum Function examples.  This includes … Continue reading →

Posted in Excel | Tagged , , , , | Leave a comment

Sean Taylor

Posted on 13/12/2015 by dougaj4

Another excellent UK musician I had never heard of, and judging by the number of YouTube hits, neither have you: Someone comments that John Martyn comes to mind, so maybe this duo is not so surprising: Sean Taylor, Wikipedia Sean … Continue reading →

Posted in Bach | Tagged , | Leave a comment

Max, Min, and Aggregate

Posted on 11/12/2015 by dougaj4

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 →

Posted in Excel | Tagged , , , , | 5 Comments

ConBeamU 4.08

Posted on 29/11/2015 by dougaj4

The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point.  The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

Announcing Excel Summit South 2016!

Posted on 28/11/2015 by dougaj4

After 2 years of organising, Charles Williams recently announced: EXTEND YOUR SKILLS This is a unique opportunity to: Learn from six of the world’s leading Excel MVP’s as they discuss the Excel topics most useful to you. Hear industry leading … Continue reading →

Posted in Excel | Tagged , , , , , | 1 Comment