LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hal Hal is offline
external usenet poster
 
Posts: 36
Default How to make a cell show average of the last 5 entries in a column?

I need to make a fixed cell display the average of the last 5 entires in a
column that will periodically have another entry added to it and may at some
point contain 50 or so entries.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Can I make Column Chart use percent and show value lunarpc Charts and Charting in Excel 3 November 8th 07 07:14 PM
Cell Entries show as decimal Saskatoon Jerry Excel Worksheet Functions 1 October 21st 07 06:12 AM
Show average value as a horizontal line in a column chart Fenil Shah Charts and Charting in Excel 4 October 1st 07 07:59 PM
make cell entries a negative number gls858 New Users to Excel 4 August 1st 05 11:00 PM
Average of column entries abfabrob Excel Discussion (Misc queries) 3 April 12th 05 02:31 PM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"