text within multiple strings, look @ dates in next column, return most recent date

Alright, this is similar to one I posted before but now I only need it to return one date, the most recent one.

e45987r, rt4352, fr65830	12Dec10	rt4352
rt7777, fr77321, e87212r	07Aug11
rt4352, fr32121, e00098r	28Feb10

In this example, rows 1 & 3 both contain the string rt4352 in different spots in the cell (there are much more than 3 rows in my actual data).

What I want to do is identify each cell in column A that contains rt4352, look at the corresponding dates from column B, then return the most recent date. In this case, I want to return 12Dec10 (not 28Feb10)

Here's what worked for finding both dates, but I don't know if I can tweak it to only return the most recent one.

Originally Posted by NBVC

You can try something like:

Please Login or Register  to view this content.

adjust ranges to suit... this assumes data is in A2:B100 and the search string of interest is in C2.

The formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down

Any suggestions?

Sorry I didn't think about the formatting making a difference (duh)

What if the date is in a custom format? m/d/yy