Returning latest date multiple criteria are met

[JMc-21]

Hi

I was wondering if anyone could help with a formula I'm trying to get right.

I'm looking for it to return the most recent date (from column A) which either of two criteria have been met (drop-down list from column B).

I've been messing around with a MAX IF formula which I can't get to work but I'm possibly on a completely wrong track doing that. I've attached a mockup spreadsheet which I hope shows what I mean better than I can explain it, along with the formula I've already been trying.

Many thanks

Jay

[Pete_UK]

You can use this array* formula in E14:

=MAX(IF((B$2:B$12="Alpha")+(B$2:B$12="Bravo"),$A$2:$A$12))

*Note that an array formula must be confirmed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.

Format the cell as a date in the style that you prefer.

Hope this helps.

Pete

[JMc-21]

Hi Pete

That works exactly as I wanted it to! Can't believe I spent hours getting it wrong and you sorted it in two mins!

Really appreciate your help.

Jay

[Pete_UK]

You're welcome, Jay - thanks for the rep.

Hope things are okay in the North East.

Pete