The following is returned in an array of dates when the 2 conditions are true. I want it to just return the most recent date. I know I can filter a filter, but the logic here is escaping me.

=FILTER(data!B:B,data!A:A=A30,data!F:F=B30)

CodePudding user response：

I would think a Maxifs() would work fine.

=MAXIFS(data!B:B,data!A:A,A30,data!F:F,B30)

CodePudding user response：

If your FILTER function is returning an array. You can use the MAX function on it to return the highest date:

=MAX(FILTER(data!B:B,data!A:A=A30,data!F:F=B30))

Documentation

• MAX