Tag Archives: Array Function

Copy non-blank rows to another sheet

Posted on 26/07/2013 by dougaj4

A thread at Eng-Tips asked for a way to display the data from Sheet2 on Sheet1, but only the rows that were not blank in Column A. There are probably ways to do it without VBA, but it seems to me … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 3 Comments

Using LatPilePY

Posted on 09/07/2011 by dougaj4

LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles.  It was presented in this post: LatPilePY.  In response to an e-mail request, this post will give step by step instructions for … Continue reading →

Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Moving Average Function

Posted on 04/05/2009 by dougaj4

The previous post presented a simple moving average user defined function (UDF).  This has been extended to provide additional functionality: A weighted average may be returned; either a linear weight with a specified step value, or a using any specified weighting … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 1 Comment

Moving averages and User Defined Array Functions

Posted on 25/04/2009 by dougaj4

I have recently needed to work with moving averages on a large-ish data set (about 10,000 rows x 10 columns), and for reasons that I will describe in the next post, decided that a User Defined Function (UDF) would be … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 8 Comments