MAX IF formula to find various highest values between a range of dates

I'm trying to extract the highest recorded speed for each site on a particular day.
Eg:
1/10/13 Site 1 was 92mph
1/10/13 Site 2 was 45mph
1/10/13 Site 3 was 39mph

...and so on through the entire date range.

I thought I had found the answer here http://www.excelforum.com/excel-prog...-criteria.html but I can't make it work as the dates in the example are consecutive whereas mine are groups of the same date which are then consecutive.

Many thanks