Is there a FORMULA for this issue? THANK YOU IN ADVANCE

Hello,

Please help, the issue goes like this,

I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have in the list with the status either DELIVERED or RECEIVED.

for example:

DATE - NAME - STATUS (DELIVERED/RECEIVED)

1/05/2015 - CCC - RECEIVED
1/08/2015 - AAA - DELIVERED
1/09/2015 - AAA - RECEIVED
1/09/2015 - BBB - DELIVERED
1/10/2015 - CCC - DELIVERED
1/11/2015 - AAA - DELIVERED
1/13/2015 - AAA - RECEIVED

so the results should be:

AAA - LAST DELIVERED - 1/11/2015
AAA - LAST RECEIVED - 1/13/2015