Excel ? Formula for moving average
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
|