C

#### Chris26

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