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: MovAv.zip

A screenshot is shown below:

MovAv UDF - click for full size view

MovAv UDF - click for full size view

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

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s