Select max value per day

[JennyReed]

I have water level data with two - four records per day. I would like to extract the highest level per day. How do I get excel to do this ?

For example: raw data looks as follows
[TABLE="width: 183"]
<tbody>[TR]
[/TR]
[TR]
[TD]01/09/2009 08:50[/TD]
[TD="align: right"]76.8[/TD]
[/TR]
[TR]
[TD]01/09/2009 14:47[/TD]
[TD="align: right"]54.3[/TD]
[/TR]
[TR]
[TD]01/09/2009 20:59[/TD]
[TD="align: right"]82.7[/TD]
[/TR]
[TR]
[TD]02/09/2009 03:14[/TD]
[TD="align: right"]48.4[/TD]
[/TR]
[TR]
[TD]02/09/2009 09:29[/TD]
[TD="align: right"]81.7[/TD]
[/TR]
[TR]
[TD]02/09/2009 15:27[/TD]
[TD="align: right"]50.4[/TD]
[/TR]
[TR]
[TD]02/09/2009 21:38[/TD]
[TD="align: right"]87.6[/TD]
[/TR]
[TR]
[TD]03/09/2009 03:51[/TD]
[TD="align: right"]44.5[/TD]
[/TR]
[TR]
[TD]03/09/2009 10:02[/TD]
[TD="align: right"]85.7[/TD]
[/TR]
[TR]
[TD]03/09/2009 16:03[/TD]
[TD="align: right"]46.5[/TD]
[/TR]
[TR]
[TD]03/09/2009 22:12[/TD]
[TD="align: right"]91.5[/TD]
[/TR]
[TR]
[TD]04/09/2009 04:24[/TD]
[TD="align: right"]41.6[/TD]
[/TR]
[TR]
[TD]04/09/2009 10:32[/TD]
[TD="align: right"]89.6[/TD]
[/TR]
[TR]
[TD]04/09/2009 16:34[/TD]
[TD="align: right"]43.5[/TD]
[/TR]
[TR]
[TD]04/09/2009 22:43[/TD]
[TD="align: right"]94.5[/TD]
[/TR]
</tbody>[/TABLE]

Max per day table would look as follows:
[TABLE="width: 177"]
<tbody>[TR]
[TD]01/09/2009 20:59[/TD]
[TD]82.7[/TD]
[/TR]
[TR]
[TD]02/09/2009 21:38[/TD]
[TD]87.6[/TD]
[/TR]
[TR]
[TD]03/09/2009 22:12[/TD]
[TD]91.5[/TD]
[/TR]
[TR]
[TD]04/09/2009 22:43[/TD]
[TD]94.5[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 177"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 177"]
<tbody>[TR]
[TD="width: 64, align: right"][TABLE="width: 177"]
<tbody>[TR]
[TD="width: 64, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

First thought, pivot table

 

[steve the fish]

Formula would be along the lines of:

=MAX(IF(INT(A1:A15)=INT(A1),B1:B15))

CNTL-SHIFT-ENTER to enter.

 

[JennyReed]

First thought, pivot table

I did think of that but what I am not sure how to do is how to filter the data so that I get only 1 value (the max value) per day.

 

[JennyReed]

Got this to work - thank you