Search code examples
excelexcel-formulapivot-tableworksheet-functionarray-formulas

Automate MIN and MAX temperatures for a certain date

I have big amount of data (60k rows) in Excel that is similar to this:

Temperature Humidity    Date
20.1        68      22-dec-14
20.3        67      22-dec-14
20.4        65      22-dec-14
20.0        64      23-dec-14
20.5        64      23-dec-14
20.9        65      24-dec-14
21.4        64      24-dec-14
23.4        64      25-dec-14
23.8        65      25-dec-14
23.9        64      25-dec-14
18.4        64      25-dec-14

I created new columns outside this table that contains the individual dates and I want to extract the MAX, MIN and possibly the AVERAGE of that date

DATE      MIN   MAX  AVG
22/Dez/14
23/Dez/14
24/Dez/14
25/Dez/14

I tried but I can't seem to find a way for Excel to work for me. Could you help me?

Solution

  • I suggest you try a PivotTable:

    SO33296377 example