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
<tbody>
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...