Thread: Return Maximum value for Specific Month(s)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
  
Posts: 247
Default Return Maximum value for Specific Month(s)
Hi Teethless mama,

Thank you - very much appreciated.

Cheers,
Sam

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

ctrl+shift+enter (not just enter)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200612/1

Reply With QuoteReply With Quote