I don't think that a pivottable will give you the info you want.

But you could use a formula.

Say your data is in A2:C500

And you put the date that you want to find in E1.

Then you can put this array formula in E2:

=MAX((A2:A500=E1)*(C2:C500))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.

You could also use a formula like:
=MAX(IF(A2:A500=E1,C2:C500))
(still an array formula -- ctrl-shift-enter)




rlo wrote:

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?

--

Dave Peterson