I need a formula that can find the last occurrence of each item in a list.
Scenario:
Column A(Products) Column B(Date of Arrival)
Socks------------------------------------Sept 2
Shoes------------------------------------Sept 3
Hats--------------------------------------Sept 3
Shoes------------------------------------Sept 4
Shoes------------------------------------
Shirts--------------------------------------

I need to get via excel formula, the latest Date of arrival per item say Sept 2 for "Socks", Sept 3 for "Hats", and Sept 4 for "Shoes". Please note that "Shoes" here has 2 Date of Arrivals as compared to "Socks" and "Hats" that have only one Date of Arrival for each. If you will notice, "Shoes" is listed 3 times wherein the last one has blank Date of Arrival. Also, "Shirts" is listed but it has blank Date of Arrival. I need then a formula that will return the desired latest Date of arrivals as I indicated above and will just return blank for the "Shirts" since it has no Date of Arrival. To summarize the desired result:

Product Latest Date of Arrival
Socks----------------------Sept 2
Shoes----------------------Sept 4
Hats------------------------Sept 3
Shirts----------------------[Blank]

Please help. Thanks.