var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Finding average of last 10
I need help.
I am working in excel and trying to write a formula that will calculate the average of the last ten numbers. I want to refresh my data and the formula with always find the last ten.
I have three columns:
column 1 - date
column 2 - mill
column 3 - levels
I have 703 rows. I wanna focus on column 3
Don't have Excel handy, but I think this should work:
=AVERAGE(INDIRECT("C" & ROWS() - 9 & ":C" & ROWS()))
For reference, this is a duplicate thread of the one in the Excel board: