I have an application that requiers excel to find out for me the hour of the
max temperature of a person in a given day. The person's temperature is
recorded in the following way in Excel:
Columns: 1 2 3
Day Hour Temperature

I want to use Pivot table and I can get the Max tempreature of the person on
all the days; however, I don't know to use Pivot table to get the Hour of the
highest temperature. A simple request... can anyone help?