View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TAL
 
Posts: n/a
Default 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