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

01/09/2009 08:50	76.8
01/09/2009 14:47	54.3
01/09/2009 20:59	82.7
02/09/2009 03:14	48.4
02/09/2009 09:29	81.7
02/09/2009 15:27	50.4
02/09/2009 21:38	87.6
03/09/2009 03:51	44.5
03/09/2009 10:02	85.7
03/09/2009 16:03	46.5
03/09/2009 22:12	91.5
04/09/2009 04:24	41.6
04/09/2009 10:32	89.6
04/09/2009 16:34	43.5
04/09/2009 22:43	94.5

<tbody>
</tbody>

Max per day table would look as follows:

01/09/2009 20:59	82.7
02/09/2009 21:38	87.6
03/09/2009 22:12	91.5
04/09/2009 22:43	94.5

<tbody>
</tbody>

<tbody>
</tbody>

<tbody> </tbody>

<tbody>
</tbody>

 

[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