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 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:

A screenshot is shown below:

MovAv UDF - click for full size view

MovAv UDF - click for full size view

This entry was posted in Arrays, Excel, UDFs, VBA and tagged , , , . Bookmark the permalink.

1 Response to Moving Average Function

  1. Pingback: Daily Download 26: Moving averages and prime numbers | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.