Filter Latest Date in Excel

Hi all,
I have a problem in extracting latest can anyone help me

I have a sheet with some coloumns and many rows
where Iam having different entrys in cells
Now my work is to count the no.of rows having
"A" in D coloumn and
"DAD" in N Coloumn

I got this count using formula =SUM((D3:D20="A ")*(ISNUMBER(SEARCH("DAD ",N3:N20))))

But now the problem is in Coloumn K Iam Having Date I want Latest date for above filtered data Can anyone pls Help me

Attached Excel Will give u Clear idea of my Requirement

Try this array formula

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter not just Enter

N.B.
Your data seems to have trailing spaces, that is why I have used "A " & "DAD " in the formula.

I have noticed this recently in many worksheets from India, how does this come about?
Are you typing "A" then spacebar then return? Or is it something else commonly done in India?

Trailing spaces are impossible to see and cause all sorts of problems when comparing strings.
Avoid this practice or clean out data by using TRIM() before proceding.

Hope this helps.

The problem is that Column K also has text entries.

Although the Max() function on its' own ignores these entries, the array formula doesn't and tries to multiply the text values, hence the #VALUE! error.

Try this array formula

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter not just Enter

It might be that you could use SUBTOTAL() and filters, rather than the array formula.
I have added this to K1

Please Login or Register  to view this content.

Filter Column D for "WL"
Then
Filter Column N Text > Begins with "Drop "

or whatever your needs might demand.

Hope this helps.

Happy to have helped.