Try the below. Please note that this is an array formula. Within the cell in
edit mode (F2) paste this formula and press Ctrl+Shift+Enter to apply this
formula. If successful in 'Formula Bar' you can notice the curly braces at
both ends like "{=<formula}"

=MAX(IF(TEXT(A2:A100,"yyyy")="2009",B2:B100))

If this post helps click Yes
---------------
Jacob Skaria


"Chris26" wrote:

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