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.