Hi, I have the following code which works on Office 365 using MAXIFS
MAXIFS(Table1[Date],Table1[Name],D13,Table1[7 Dwarf],H13,Table1[Type],"<>"&"*Yes*"))
Essentially it provides the maximum date that matched 3 criteria (name=D13, 7 dwarf = H13, type not contain Yes)
Problem is I'm trying to...