MAXIFS alternative

[Steven101]

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 replicate for users not in O365

I have tried the array

{=MAX(IF(Table1[Name]=D12,IF(Table1[7 Dwarf]=H12,IF(Table1[Type]<>"*Yes*",Table1[Date]))))}

but no joy.

any help would be appreciated

Thanks Steven

 

[steve the fish]

Try like this:

=MAX(IF(Table1[Name]=D13,IF(Table1[7 Dwarf]=H13,IF(NOT(ISNUMBER(SEARCH("yes",Table1[Type]))),Table1[Date]))))

 

[Steven101]

Perfect, thanks