Quote:
Originally Posted by oscarlimerick
I dont really want to check row wise, I want to check by the date
|
Try array-entering in cell G5:
Code:
=MAX(IF(((A5:A1000<INDEX(A5:A1000,MATCH(MAX(A5:A1000),A5:A1000,0)))*(B5:B1000>INDEX(B5:B1000,MATCH(MAX(A5:A1000),A5:A1000,0)))),A5:A1000))
and in cell E5:
Code:
=INDEX(B5:B1000,MATCH(G5,A5:A1000,0))
No dates with with no score.