#### ctownballer03

##### New Member

- Joined
- Sep 7, 2017

- Messages
- 4

Specifically I would like to write this formula in B35 such that it calculates standard deviation on data that looks like: (0;A1-A35). So then I could get 3 year standard deviation on the last 35 months of data and 0, and drag that down all the way to B100 to calculate this rolling standard deviation on last 35 months of data and 0.

I spent a shockingly large amount of time trying to get this to work without success so curious if anyone is aware of a way to do this (ideally w/o VBA).

Thanks for any help here and let me know if my question isn't clear in any way.