View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
reno reno is offline
external usenet poster
 
Posts: 93
Default moving average & rank

have listing of stores and weekly sales, want to calculate the last four
weeks moving average, e.g, this week (wk4) would be weeks 1-4, next week
(wk5) would be weeks 2-5 and so forth.

second caluculation would be to rank the stores by weekly sales on same four
week moving average.
thx