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 array.
• The initial values may be returned either as #N/A, or with the current average values.
• Zeroes in the data may be either treated as values or ignored.
• Rectangular ranges may be specified to be treated as arranged in either columns or rows.

The function may be downloaded from: MovAv.zip

A screenshot is shown below:

MovAv UDF - click for full size view