ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/446288-formula.html)

bryan gaudette

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

Spencer101

Quote:

Originally Posted by bryan gaudette (Post 1602561)

Hi Bryan,

What do you mean by "log in to that column"???

James Ravenswood

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

darbary

Quote:

Originally Posted by bryan gaudette (Post 1602561)

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

All times are GMT +1. The time now is 02:20 PM.