Tag Archives: Array Function

Copy non-blank rows to another sheet

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

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

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

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