This function will return the standard deviation for a named set of data over a defined period of months.
So for example if we have
Range = "START_DATE" = 30/6/2012
Range = "END_DATE" = 31/12/2015
Range = "DATA_NAME" = UK Interest Rate
Then the function will return the standard deviation of for Uk interest rates over the period June 12 - Dec 15
All the data is on sheet2. In column A we have month end dates in chronological order. In row 2 we have the data names. So for example in cell AH2 the data name is UK Interest Rate. The function must find the monthly data for the defined period from column AH and return the standard deviation.
I hope that makes sense. Many Thanks, Mark
So for example if we have
Range = "START_DATE" = 30/6/2012
Range = "END_DATE" = 31/12/2015
Range = "DATA_NAME" = UK Interest Rate
Then the function will return the standard deviation of for Uk interest rates over the period June 12 - Dec 15
All the data is on sheet2. In column A we have month end dates in chronological order. In row 2 we have the data names. So for example in cell AH2 the data name is UK Interest Rate. The function must find the monthly data for the defined period from column AH and return the standard deviation.
I hope that makes sense. Many Thanks, Mark
Last edited: