Go Back  PPRuNe Forums > Misc. Forums > Computer/Internet Issues & Troubleshooting
Reload this Page >

Spreadsheet - Help Needed Please!


Notices
Computer/Internet Issues & Troubleshooting Anyone with questions about the terribly complex world of computers or the internet should try here. NOT FOR REPORTING ISSUES WITH PPRuNe FORUMS! Please use the subforum "PPRuNe Problems or Queries."

Spreadsheet - Help Needed Please!

Old 20th September 2001 | 14:14
  #1 (permalink)  
Thread Starter
20 Anniversary
 
Joined: Jun 2001
Posts: 3,991
Likes: 8
From: UK
Post 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?
fireflybob is offline  
Old 20th September 2001 | 14:45
  #2 (permalink)  
20 Anniversary
 
Joined: Jun 2001
Posts: 382
Likes: 0
From: Intentionally Left Blank
Post

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.
Icarus is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.