No, I only have one column of data I want the MWA from.
eg: B1:B4 is :10,20,15,14
3 period moving average in C3 is (10*1 + 20*2 + 15*3)/(3*2*1)
3 period moving average in C4 is (20*1 + 15*2 + 14*3)/(3*2*1)
etc
I cannot use another column and multiply the values, as the values I
multiply by (the weights) change for each cell.
Hope this makes some sense :).
Ori
--
Ori
------------------------------------------------------------------------
Ori's Profile:
http://www.excelforum.com/member.php...o&userid=37675
View this thread:
http://www.excelforum.com/showthread...hreadid=572825