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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count + condition 1
Start and End date 2
macro help 1
LOOKUP function between two dates in Excel 2007 6
LOOKUP within a 1
Lookup and dates 5
pull data from one table to another if multiple conditions are met 3
How to Count Dates in 2 Lists 2

Top