Delete Duplicates According to dates

[mccreaso]

Hi All,

Have a problem.

I have a list of 30000+ customers in an excel spreadsheet. The problem is that there are duplicate customers. The spreadsheet contains 3 columns:

ID NUMBER NAME START DATE
10000000012 Name26818 30-Aug-06
10000000012 Name29818 01-Sep-05
10000000012 Name29818 05-May-05
10000000060 Name27117 02-Aug-06
10000000149 Name27230 24-Nov-06

What I want to do is delete duplicates according to the latest date. Forexample the above would become

ID NUMBER NAME START DATE
10000000012 Name26818 30-Aug-06
10000000060 Name27117 02-Aug-06
10000000149 Name27230 24-Nov-06

Records 2 & 3 where deleted as they were an earlier date. i have attached the spreadsheet for you to have a look at!

Hope you can help,
mccreaso