Hi

I have a number of data vaules (Col-B) per day for a number of years. Is
there a formula that I could use to extract the MAX value of Col-B for say,
Year 2000, 2001, 2002 etc. I have a number of series of data, and each series
has approx 10,000 lines of data hence be easier if use formula.
The frequency of the data values, varies, there could be 10 on one day, 5
the next etc.
I have previously used SUMPRODUCT to get the sumation of similar data but
how do I get the MAX value. Any ideas?

The Data is as follows.

Col-A Col-B

01/01/2000 09:10:18 0.005
01/01/2000 14:22:08 0.008
01/01/2000 23:14:28 0.004

02/01/2000 03:08:36 0.011
02/01/2000 11:10:40 0.018

31/12/2008 09:10:18 0.009


Many Thanks
Chris