finding the latest date in a list of dates

**easty** · 01-13-2010, 11:27 PM

Hi There,

I need a formula that will look at a list of dates and return the latest date on which a particular "value" occurred.

Please see the below example
A B
1 Date Adviser
2 14/1/09 PE
3 15/2/09 BM
4 1/04/09 SS
5 3/5/09 PE
6 23/7/09 SS
7 4/10/09 PE
8 2/1/10 BM

I want a formula that will look at column B and tell me when the latest date in which PE for example occurred... the answer being 4/10/09

thanks

**Paul** · 01-13-2010, 11:39 PM

Hi Easty,

You can use the array formula:

=MAX(IF(B2:B10="PE",A2:A10))

After typing this formula, you must press CTRL+SHIFT+ENTER, not just ENTER. When done properly, Excel will insert braces around your formula.