I am using the following formula to calculate the average daily temperature value in column B (see image below) for each day over a 15-year meteorological record (temperature values are in column B and there are multiple per day). Column A contains the date that the record was taken and column D is a list of unique dates to get the average daily temperatures for.
I would like to replicate this formula for the daily maximum and minimum but do not have
MINIFS formulas in my version of Excel. Is there a workaround to create these formulas?
In the image below, I am trying to calculate the maximum daily temperature in column F; for 01.02.2005, this would be -2.7 for example