I have a spreadsheet that collects data on temperature every 5 minutes each day for several months. The date/time is in column A and the temp is in column B. I need a way to find the max temp each day and place the date (once each day) in column C and the max temp for that day in column D. column C and D will be much shorter columns (as there will only be one cell of temp data for each day).
Thanks for your help!