Forum Discussion
Search for max in data related to a date
We're looking for a formula or method to search the maximum in a time range in a table which contains 2 coloms. First colom contains dates (no relation between dates, random) Second colom contai...
In C2:
=MAXIFS([Mesure],[Date],">="&EDATE([@Date],-12),[Date],"<="&[@Date])
In D2:
=MAXIFS([Mesure],[Date],">="&[@Date],[Date],"<="&EDATE([@Date],4))
In E2:
=MAXIFS([Mesure],[Date],">="&[@Date],[Date],"<="&EDATE([@Date],12))