picking the newer of multiple entries

I have a long table like this:

Car,date last washed
Civic, 11/1/2012
F150, 5/4/2013
Corvette, 7/3/2013

If I washed the Corvette, I'd add another row to it:

Corvette, 10/22/2013

And I would like to remove the "Corvette, 7/3/2013" entry. What's the easiest (read: least user intervention) way of doing this?

Not sure if you had something in mind for this, it sounds like the 'hard' part of this is searching the list and updating the date? I would think the easiest way would be to add a filter to the entire list. Then you could select the filter arrow, easily type in the make/model, and update the date.

Well, my task is to reduce human intervention for this worksheet so filtering and typing is out of the question. There are hundreds of entries in this table, and possibly hundreds of changes each time.

Is there any way for me to paste this into Sheet1:

Car,date last washed
Civic, 11/1/2012
F150, 5/4/2013
Corvette, 7/3/2013
Corvette, 10/22/2013

And for excel to show me this on Sheet2:

Car,date last washed
Civic, 11/1/2012
F150, 5/4/2013
Corvette, 10/22/2013

In this way, the user only needs to cut and paste.