BigDelGooner
Board Regular
- Joined
- Aug 17, 2009
- Messages
- 197
Please help someone!!
I have a sheet where I would like to calculate the 12m standard deviation of a given set of figures based on the month selected (i.e. 12 months to 30/09/09 or 31/10/09).
I know the basic formula for what I am trying to do is =STDEV(Data!X63:X74) for the 12 months to 30/09/09 but what can I add to make this formula dynamically change the range to =STDEV(Data!X64:X75) for the 12 months to 31/10/09.
All of the data is in a named range called 'Data_Range' with the EOMONTHs in the first column which I was hoping might work as a reference for this formula.
Any ideas guys?
I have a sheet where I would like to calculate the 12m standard deviation of a given set of figures based on the month selected (i.e. 12 months to 30/09/09 or 31/10/09).
I know the basic formula for what I am trying to do is =STDEV(Data!X63:X74) for the 12 months to 30/09/09 but what can I add to make this formula dynamically change the range to =STDEV(Data!X64:X75) for the 12 months to 31/10/09.
All of the data is in a named range called 'Data_Range' with the EOMONTHs in the first column which I was hoping might work as a reference for this formula.
Any ideas guys?