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
|