| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula
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 |
|
#2
|
|||
|
|||
|
Quote:
What do you mean by "log in to that column"??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
=AVERAGE(OFFSET(A4,MATCH(2,1/(A4:A84<0))-1,,-10))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key |
|
#4
|
|||
|
|||
|
Quote:
i need to update data to column and want a formula for AVERAGE that averages just the last 12 data - thanks - darbary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| extract formula result form cell without running formula again | Excel Programming | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
