Delete duplicates

[joegr]

I have a list that I would like to delete rows that have a duplicate name. Easy enough.

But I have dates associated with the contacts and I would like to leave the row with the latest date...

7/30/12	Billy Rise
9/27/12	Billy Rise
10/18/12	Billy Rise
8/21/12	Bob Steel
8/21/12	Bob Steel
12/9/12	Bob Welch
2/8/13	Bob Welch

<tbody>
</tbody>

So in this case I would like as a result...

10/18/12	Billy Rise
8/21/12	Bob Steel

<tbody>
</tbody>

2/8/13	Bob Welch

<tbody>
</tbody>

Also, I would like to have only one date/contact row if there is a duplicate of the date (example: 8/21/12 Bob Steel)

Thanks in advance.

 

[Verald]

Assuming using 2010+ (and I believe 2007)

First sort by date.

Then under Data tab, select Remove Duplicates and only un-check column A.