remove duplicate email subject except the first and last email of the same subject

[shafiq2]

Hi,

I have exported email from outlook to excel, now I want to delete the duplicate email subject expect the first and the last email of the same subject.

any help will be much appreciated.
for Exp.

Subject Received Flag Completed Date
Report 12/09/2014 16:20 16 September 2014
Report 12/09/2014 16:05 16 September 2014
Report 12/09/2014 09:02 18 September 2014
Report 11/09/2014 17:13 16 September 2014
Report 12/09/2014 16:20 16 September 2014
Report 12/09/2014 16:05 16 September 2014
Report 12/09/2014 09:02 18 September 2014
Report 11/09/2014 17:13 16 September 2014
Action to be taken 16/09/2014 13:11 18 September 2014
Action to be taken 16/09/2014 13:07 18 September 2014
Action to be taken 15/09/2014 13:43 18 September 2014
Action to be taken 16/09/2014 13:11 18 September 2014
Action to be taken 16/09/2014 13:07 18 September 2014
Action to be taken 15/09/2014 13:43 18 September 2014

from the above email subjects I want to keep the first email with Minimum date and the last email with Maximum date and the rest to be deleted or hidden.

Regards,

 

[shafiq2]

Or copy the maximaum date "Flag Completed Date" of each subject and past it next to minimum date of received of the same subject and the rest to be deleted or hidden.

For Example!
Sample of Data

Subject	Received	Flag Completed Date
Report	12/09/2014 16:20	16/09/2014 00:00
Report	12/09/2014 16:05	16/09/2014 00:00
Report	12/09/2014 09:02	18/09/2014 00:00
Report	11/09/2014 17:13	16/09/2014 00:00
Action to be taken	16/09/2014 13:11	18/09/2014 00:00
Action to be taken	16/09/2014 13:07	18/09/2014 00:00
Action to be taken	15/09/2014 13:43	18/09/2014 00:00

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Result

Subject	Received	Flag Completed Date
Report	11/09/2014 17:13	18/09/2014 00:00
Action to be taken	16/09/2014 13:07	18/09/2014 00:00

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Regards,

 

[shafiq2]

This seems to be challange but not for Excel experts