View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
 
Posts: 150
Default (Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month

In article <6e1d2b933a4f7@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,


Hi Sam!

Thank you for reply and assistance.


You're very welcome!

How do I return the Maximum value from the same set of data rather than the
Numeric Label?


Try...

=MAX(INDEX(C5:AO436,MATCH(1,IF(DAY(A5:A436)=DAY(A2 ),IF(MONTH(B5:B436)=MON
TH(B2),1)),0),0))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!