Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc

[email protected] luc.van.straaten@philips.com is offline

external usenet poster

Posts: 2

Calculating moving average

I would like to calculate the 2-period moving average of a dataset in
A1:A20. I understand that this can be done by AVERAGE(A1:A2) and the
other moving averages will appear in the selected column when
"dragging" the formula to the other cells of the column. My problem is
that i would like to see the results diagonally instead of vertically
(B3,C4,D5,E6,F7 etc. instead of B3,B4,B5,B6,B7 etc.) Can somebody help
me?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating average with moving startpoint	broer konijn	Excel Discussion (Misc queries)	4	June 23rd 06 08:20 AM
calculating moving average	[email protected]	Excel Worksheet Functions	1	May 14th 06 11:13 AM
Moving average	Hunterbo	Charts and Charting in Excel	0	August 3rd 05 09:13 PM
calculating moving average	odey1234	Excel Worksheet Functions	2	March 29th 05 02:06 PM
Moving average	Mike B	Excel Worksheet Functions	8	March 21st 05 04:41 PM

All times are GMT +1. The time now is 08:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us