Forum Discussion
Index & Match Function
Perhaps there are no data for 36 and 60 months ago?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
Perhaps there are no data for 36 and 60 months ago?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
Thank you, Hans. Problem solved.
However, I have another question. I am calculating standard deviation for a data set. I have tried the following two formulas on the same data set. However, I am getting different results. Any thoughts as to why? Thank you.
=STDEV.P(FILTER(D$48:D$437,$A$48:$A$437>EOMONTH($B7,-60)))*SQRT(12)
=STDEV.P(D146:D206)*SQRT(12)
Hi Richard,
That is impossible to answer without seeing a copy of the workbook.
Thank you very much for your help. See attached.
Thanks.
A12:A23 contains the dates in 2014.
$A$11:$A$400>EOMONTH($C3,-12) includes all dates in 2014 and later, so a much larger range.
If you want to filter for the year of the date in cell C3:
=STDEV.P(FILTER(C$11:C$400,YEAR($A$11:$A$400)=YEAR(C3)))*SQRT(12):