![]() |
Spreadsheet - Help Needed Please!
Using MS Word and I want to display a figure which is the average of the last 14 entries (like a moving average) - anyone know how I do this please?
|
Assuming that you are using a table to store the 'last 14' entries, then use the;
TABLE/FORMULA menu item to put a formula in the 15th cell of the particular column in the table. From the dialogue box you can enter the formula you may need to use similar to that done in Excel; i.e. AVERAGE(A1:A14). Otherwise, why not set up a speadsheet in Excel and CUT/PASTE it into your MS Word document. Or you could use the INSERT/OBJECT menu item to insert a (fresh) Excel worksheet into your document. |
| All times are GMT. The time now is 03:58. |
Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.