Forum Discussion
Standard Deviation and Formula Look Up
Hello. I am having an Issue with my standard deviation not adjusting based off the date when looking up values. So the formula will not find the date in the table and update the averages based off the table. I have been struggling with this for a good few days and am beyond frustrated. Here is the book.
Any suggestions or answered would be GREATLY appreciated. I plan on using the data on sheet 3 to create a pivot table and would like to compare the current subject selected the the average of the other subjects. So I am using the T-Scores to compare the subjects to each other.
See the attached version.
17 Replies
The formula in C8 should be
=STDEV.S(IF(C2=POWER[Date],POWER[Weight],))
i.e. with [Date] instead of [@Date]. And it should be confirmed with Ctrl+Shift+Enter to turn it into an array formula.
So I made it an array formula and now I am getting standard deviation values at 117 for the 2/16 when it should be 38. But I am also now getting values for 2/17 so that better.
I added that [@Date] to see if would change anything. It did not. HansVogelaar
