Hi Domenic,

That's Brilliant! Thank you very much.

Cheers,
Sam

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

Domenic wrote:
Try...

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

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

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