Tag Archives: array functions

More on TrimRange and the Drop Function

Posted on 20/11/2025 by dougaj4

A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator: It also looks at using the Drop Function to exclude a specified number of rows and/or columns from the top or … Continue reading →

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

The TrimRange Function

Posted on 05/11/2025 by dougaj4

I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 2 Comments

RC Design Functions 9.02; DevLength function

Posted on 13/09/2022 by dougaj4

The RC Design Functions spreadsheet has now been updated to Version 9.02, and is available for free download from: RC Design Functions9.zip Changes in the new version include: The new DevLength function returns reinforcement development length to AS 3600, AS … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , , | Leave a comment

Excel Dynamic Arrays

Posted on 08/12/2019 by dougaj4

Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme.  They are now being published to general subscribers through Office 365 monthly updates: Further information is given at: Easier array formulas and Dynamic array … Continue reading →

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

Using VBA Evaluate as an Array Function

Posted on 24/08/2018 by dougaj4

I recently discovered from a thread at  Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function.  As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , | 2 Comments