@ChrisHeathcote Thank you very much! I understand moving average calculation. I try to make standard deviation calculation based on user's input period setting. example1 user input=3weeks Week 5's standard deviation is calculated based on figure on Week 3, Week 4 and Week 5 Week 4's standard deviation is calculated based on figure on Week 2, Week 3 and Week 4 … example2 user input=4weeks Week 5's standard deviation is calculated based on figure on Week 2, Week 3, Week 4 and Week 5 Week 4's standard deviation is calculated based on figure on Week 1, Week 2, Week 3 and Week 4 … if user's input count of weeks is limited, I think I can write formula with many IF-THEN-ELSE. However I want try to set calculation with no limit of count of weeks. Do you have any ideas for this? But I want function Do you think it is possible to c
... View more