conditional maximums

[Carlos]

I'm trying to get a function to do the equvilant of a "MaxIF" in excel.

Eg max wage of Davids

My application will be for
Name Date Notes

Looking for last note for a person.

 

[Max]

Assuming data in cols A to C (Name, Date, Notes) from row2 down
then something like this in say, D2, array-entered (press CTRL+SHIFT+ENTER):
=INDEX(C2:C9,MATCH(MAX(IF(A2:A9="David",B2:B9)),IF(A2:A9="David",B2:B9),0))
Adapt the ranges to suit your actual extents. Dates in B2 down are assumed
real dates.