Forum Discussion
Dtripple40
Feb 17, 2021Copper Contributor
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 th...
- Feb 17, 2021
See the attached version.
Dtripple40
Feb 17, 2021Copper Contributor
Thank you!! That Was a big time help.
If you are feeling really nice. I cant seem to get the subject name to look up by the date and name. I will end up having repeated subjects. Like two A's. So this weigh the book could look at the date and name and find the correct data for that day. SO for subject A on the 2/17 the correct data would come up. I have only come up with
=if(c2=POWER[DATE]&B4=POWER[NAME],POWER[WEIGHT].....
I can not figure what would be next to have the book look up the name, date, then the metric associated with that name and date( HansVogelaar
HansVogelaar
Feb 17, 2021MVP
I'll get back to you later, no time now.