Hi,
Here is a clip from the data I need to select from.

11-Jun IP D
12-Jun IP D
12-Jun IP D
13-Jun IP D
14-Jun IP D
14-Jun IP D
16-Jun IP D
17-Jun IP D
18-Jun IP D
18-Jun IP NG
18-Jun SP D

I need to write a formula that returns only the the most recent (highest)
date from column A, if the corresponding entry in column B equals "IP". In
other words, I want to know the date of the most recent entry of "IP" in
column B.

Does anyone have a solution for my problem?

Thanks,

--
Jerry