Find Daily Maximum from Hourly Data

Hi all,

This seems like a "simple" question, but after struggling for awhile I thought I would ask for some help.

I have two columns of data:

Column A - Dates of Hourly* Readings

Column B - River Level Elevation data. (could be anything though: rainfall, temperature, etc.)

So, it looks like this:

10/17/2011 562.123
10/17/2011 562.431
10/17/2011 562.431
...more readings
10/18/2011 562.312
10/18/2011 562.342
...more readings


*However, the "catch" is that there are not always exactly 24 hourly measurements each day (sometimes only 18-24), as the data logger isn't perfect. Oh, and there are about 10,000 readings in total


All I would like to do is have a summary of the maximum elevation measured on each day.

10/17/2011 562.510
10/18/2011 562.410
10/19/2011 562.450
...

If someone provide me with help on this issue or point me in the right direction that would be great!

Thanks!

Thank you for your reply oeldere! I'm afraid I've never used Pivot Tables before, so perhaps you could break it into smaller steps for me.

Here's what I tried:

1) I managed to insert a Pivot Table, and "Checked" the two fields "Date" and "Elevation" to add to the report.

2) I changed the Values function to "Maximum".

See the attached image/xls for where I'm at. Right now it's just showing the Maximum of the entire data set and all the data is still shown.

Where should I go from here?

Thanks!

Great! Thank you for this help and I am definitely now interested in learning more about Pivot Tables!

Much Appreciated!