Forum Discussion
@Pivot Table and analysis of weather data
I have a personal weather station with almost 14 years of data recorded at 1/2 hour data points. I have turned this txt data into an excel database which has 225,000 records. In the data is low temperature for each 1/2 hour data point. How would I use pivot tables to extract out the highest low temperature for each day? I am not expert enough at pivot tables to know how to filter data so that I only extract out the highest low temperature for each day rather than the low temp for each 1/2 hour datapoint.
11 Replies
monicard01 Perhaps like in the attached (simplified) example?
Not sure what you mean by "highest low temperature", though. I assumed you wanted the lowest temperature on any given day and used "Min." in the value field. Use "Max." if you really want the highest (i.e. warmest) of all the low temperatures.
That seems to work. I wanted to find out which days had the highest minimum temperature. How do you concatenate the date and time fields together?
monicard01 In my example I just entered date and time into one cell. But if you have date and time in two different cells, make sure that they are formatted as date and time respectively. Then you can create a time stamp by adding the two together and apply a custom format " dd/mm/yyyy hh:mm ". See attached.
