(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!
|