Welcome to FreeSoftwareServers Confluence Wiki
https://exceljet.net/formula/max-if-criteria-match
{=MAX(IF(criteria_range=criteria,value_range))}