View Single Post
  #1   Report Post  
jones285 jones285 is offline
Junior Member
 
Posts: 0
Default Duplication Deletion

Hi

I was wanting to write a macro that deletes duplicate lines but only if they include a date, please see below for example:

Thursday 20/01/2011
21:00 Delete: Golden – Rainbow 1
Insert: Golden – Rainbow 1
Thursday 20/01/2011
21:00 Delete: Golden – Rainbow 1
Insert: Golden – Rainbow 1

Friday 20/01/2011
21:00 Delete: Golden – Rainbow 1
Insert: Golden – Rainbow 1

Friday 20/01/2011
21:00 Delete: Golden – Rainbow 1
Insert: Golden – Rainbow 1

I would want to keep all lines containing Golden - Rainbow but deleting all but the first instance of the date.

Any help would be greatly appreciated

Thanks