Formual that provides a monthly average smothing spikes

[mburke]

How do i create an excel formula that will give me a monthy average (using 12 months of actual purchased data) smoothing out spikes.
one example below. I consider Jan, Apr & Sept spikes. I need to come up with an average of material I should have on-hand each month to cover sales.
However, I don't want to figure in spikes.

Nov 3 units
Dec 2 units
Jan 15 units
Feb 2 units
Mar 8 units
Apr 13 units
May 4 units
Jun 3 units
Jul 2 units
Aug 9 units
Sep 11 units
Oct 4 units

[Pepe Le Mokko]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.
http://www.excelforum.com/excel-form...th-spikes.html