Forum Discussion
Solved
Selecting the max value from a date range using repeated measures
I have thousands of IDs, some of which have multiple visits or occurrences. Each occurrence has a value and a date. My objective is to identify the max value out of the repeated occurrences for a spe...
See the attached version.
This looks great - thanks a lot! Would you by chance know why, when I go to use that same formula in my master file, after entering the formula and using SHIFT+CTRL+ENTER, I receive the #VALUE! error? When I copy and paste it within the short except file that I shared it works (doesn't produce an error), but everywhere else it's leaving me with error responses. Thanks!
Could the RESULT_VALUE column contain invalid entries, for example text values? Try this formula in H2, also confirmed with Ctrl+Shift+Enter:
=MAX(IF(($A$2:$A$55665=G2)*($C$2:$C$55665>=DATE(2016,1,1))*($C$2:$C$55665<=DATE(2017,12,31)),$E$2:$E$55665))