Hi all,

I have been working on the following problem with little success. I welcome your suggestions. I have two columns of data. The first is the combined date and time at five minute intervals(e.g., 5/5/2010 13:25). The second is the temperature at each time. I have formed a pivot table and grouped the data by days-months-years in the first PT column, in order to then find the maximum temperature for each day in the second PT column. The problem I have is that I would like to know the exact date and time that the maximum occurs for each day. I was hoping that there was an option for this in pivot tables, but I can not find one. I've also been messing around with MATCH and INDEX, but with no success. I'm not a vba person so I would like to stick to programming this with Excel functions. Thanks for any help.