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,
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,