Excel ? Formula for moving average

T

TAL

Bottom Qtile 410 is the answer (formula is =MIN(C386:C486) )
based on 52
weeks of entries,
each number
being a week.
C386 April 9/05
C486 April 9/06
Is it possible to have a formula that allows C386 to move to C387 & C486
moving to C487 as each week comes along.
C387 becomes April 16/05 C487 becomes April 16/06

Many Thanks
TAL
 
R

Ragdyer

Don't know if I quite understand your question.

Can't you just copy the formula down the column, where the cell addresses in
the formula will *automatically* increment to the ranges that you're looking
for?

=MIN(C386:C486)
=MIN(C387:C487)
=MIN(C388:C488)

OR ... perhaps you're looking to keep the cells empty (blank) until data is
entered into the appropriate cells:

=IF(C486,MIN(C386:C486),"")
And copy down as needed.
 
Top