=MAX(IF(MONTH(A2:A100)=1,B2:B100))

ctrl+shift+enter (not just enter)


"Sam via OfficeKB.com" wrote:

Hi All,

I have a dynamic named range called "Data" that spans 10 columns and many
rows.

I would like to have the maximum value for the month of Jan (January - month
will vary) returned for column number 6. The month is a full date eg:
01/01/2006 using a custom short format "mmm" = Jan.

Column 2 = Full Date formatted as month "mmm"
Column 6 = Numeric Values - max value to be returned
Column 7 = Numeric Values - max value to be returned
Column 8 = Numeric Values - max value to be returned

Cheers,
Sam

--
Message posted via http://www.officekb.com