Category Archives: Excel

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

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

Importing Text Files; Unix Format

Posted on 10/11/2015 by dougaj4

Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details).  This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading →

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