=MAX(C2:C9*(A2:A9=MAX(A2:A9)))
will do a similar job when entered as an array function (ie with ctrl-sh-enter)
Has the advantage that it will find the larger of two values against the same date, can be adapted to use more criteria (eg a particular person) and it can be used to look to the left instead (though this could also be achieved using an INDEX and MATCH combination and I can't think I'd really use it unless I were trying to be deliberately obscure!)
Discussion on:
- Keyboard Shortcuts:
- Prev
- Next
- Toggle

































