Formula - ExcelBanter

darbary

Junior Member

Posts: 1

Quote:

Originally Posted by bryan gaudette

Hi,
I'm trying to average the last 10, in a column of numbers

the column is a4 - a84, i want to average the last 10 in that column,
and have it so it averages the last 10 as i log in to that column.

thanks for any help

Bryan

i have a similar problem, did you get any simple solution?
i need to update data to column and want a formula for AVERAGE that averages just the last 12 data - thanks - darbary

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
Build formula using field values as text in the formula referencing another workbook	solardirect	Links and Linking in Excel	6	June 4th 12 10:47 PM
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula	PJ[_3_]	Excel Worksheet Functions	2	June 2nd 10 03:45 PM
extract formula result form cell without running formula again	jason	Excel Programming	0	August 6th 09 07:40 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro	[email protected]	Excel Programming	1	July 20th 06 07:58 PM
Commenting custom formula fields/formula on formula editor	Muxer	Excel Programming	2	July 24th 03 01:02 AM

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

Menu

About Us