Delete Duplicates According to dates

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

Which is it you would like to do, delete duplicates or delete old dates?, if you want to delete old dates by what criteria? i.e a year old, week old, or do you just want to delete all entries for a customer that are older than the current one?

Regards,
Simon

Originally Posted by Simon Lloyd

Which is it you would like to do, delete duplicates or delete old dates?, if you want to delete old dates by what criteria? i.e a year old, week old, or do you just want to delete all entries for a customer that are older than the current one?

Regards,
Simon

I want to find the duplicates and keep the latest and delete the older ones. So its yes to the final question "delete all entries for a customer that are older than the current one?"

mccreaso