Formula help - last date in a range with criterion

[virtuosok]

Hi,
I am likely missing something very obvious... can you tell me what is wrong with the formula as it currently stands? I am trying for it to return the last date with 1 criterion.
Here's the source tab:

...and here's the tab with the formula in cell O10; I expect it to return the value from cell N3 above, i.e. 10 Jan 2020 but it returns zero:

 

[Fluff]

Shouldn't it be returning N8 rather than N3?
The values in col A are left aligned, which suggest they are text & not numbers, if that is the case, is col B also text?

 

[virtuosok]

Indeed this should be N8 rather than N3, that's why I need formulas
Thanks for pointing me in the right direction.
I am also trying a regular formula (versus array formula), and this one seems to work well:
=MAX(INDEX((Prescreening!B10=IWRS002!$A$2:$A$3000)*IWRS002!$N$2:$N$3000,))
However is it possible for it to return an empty string, if there are no matches? It returns zero which is auto-formatted to 1/0/1900

 

[Fluff]

How about

=IFERROR(1/(1/MAX(INDEX((B10=IWRS002!$A$2:$A$3000)*IWRS002!$N$2:$N$3000,))),"")

 

[virtuosok]

How about

=IFERROR(1/(1/MAX(INDEX((B10=IWRS002!$A$2:$A$3000)*IWRS002!$N$2:$N$3000,))),"")

Perfect! This works! Thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback.

 

[virtuosok]

So we sorted the "last date", now what about the first date in the range?
If I just change this formula
=IFERROR(1/(1/MAX(INDEX((B10=IWRS002!$A$2:$A$3000)*IWRS002!$N$2:$N$3000,))),"")
with
=IFERROR(1/(1/MIN(INDEX((B10=IWRS002!$A$2:$A$3000)*IWRS002!$N$2:$N$3000,))),"")
...it doesn't work. What else should I tweak?

 

[Fluff]

How about

=IFERROR(1/(1/MIN(IF(B10=IWRS002!$A$2:$A$3000, IWRS002!$N$2:$N$3000,10^10))),"")

needs CSE entry

 

[virtuosok]

Interesting enough, the MAX formula works both with CSE and without CSE, but the MIN one does not... any other ideas please?

 

[Fluff]

That's why I said it needs CSE entry.
What is wrong with the MIN formula I provided?