Max Date + condition

A

abc2002

Hi all!

In column 1, I have dates. In column 2, I have criterias. How can I ge
the max date matching criteria in column 2.

Example:

Col 1
2004-08-01
2004-08-01
2004-08-02
2004-08-01
2004-08-05

Col 2
AA
ABC
AA
CC
CC

How to get max date of AA ? I should get 2004-08-02

Thank you
 
F

Frank Kabel

Hi
try the array formula (entered with CTRL+sHIFT+ENTER):
=MAX(IF(B1:B100="AA",A1:A100))
 
Top