Excel VLOOKUP or DMAX Challenge

I have been trying the have a report of equipment that tells me when was the last time it worked and how many hours it worked
This is the sample data.

Date Equipment Available to Work Hours Worked
7/14/14 ART. 330-01 YES
7/14/14 ART. 330-05 YES
7/14/14 ART.460E -08 YES 20.5
7/13/14 ART. 330-01 YES 2.0
7/13/14 ART. 330-05 YES
7/13/14 ART.460E -08 YES 14.5
7/12/14 ART. 330-01 YES 20.0
7/12/14 ART. 330-05 YES
7/12/14 ART.460E -08 YES 20.0
7/11/14 ART. 330-01 YES 16.0
7/11/14 ART. 330-05 YES 10.0
7/11/14 ART.460E -08 YES 16.0

I am looking to generate this summary report

Summary
Equipment Last Day Worked Total Hours Worked
ART. 330-01 7/13/14 2.00
ART. 330-05 7/11/14 10.0
ART.460E -08 7/14/14 20.5

Thanks a lot for your help.

try..
a definite solution..
I have used array formula so use ctrl + shift + enter to enter the formula..



Don't forget to click *

Using humdingaling solution.
Thanks for responding but unfortunatelly the output is not correct. E.G. Equipment ART.460E-8 last day worked is 7/14/2014 output says 7/12/14 and fro ART.330-05 date is incorrect. Besides that the hours worked for last day does not correspond neither ART.460E-8 should be 20.5 instead of 20, ART.330-01 should be 2 instead of 0.

Hopping you can help me again.

Thanks

Using Vikas_Gautam & gak67 solution.
Output is not correct all last used dates shows wrong dates and some of the hours worked for the last day do not correspond neither.
Thanks a lot for your help hopping you can find a solution.

I have two different sets of Data i.e Payments & Returns on different sheets and i want to sort out those who filed returns & paid, those who filed & did not pay and those who paid and did not filed the return. How can i do it using Excel 2007?

It worked thanks a lot !!!!!

A bit of correction..
with absolute solution..






Don't forget to click *