URGENT!!!! Special sorting!!!

[moonlight22]

Hi,

I am in desperate need.
I have a file which looks similar to the data below:

[TABLE="width: 304"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]20140930[/TD]
[TD]3344[/TD]
[TD]XYZ[/TD]
[TD]141[/TD]
[TD]AAB7[/TD]
[/TR]
[TR]
[TD]20140430[/TD]
[TD]3344[/TD]
[TD]XYZ[/TD]
[TD]141[/TD]
[TD]AAB7[/TD]
[/TR]
[TR]
[TD]20140930[/TD]
[TD]3344[/TD]
[TD]XYZ[/TD]
[TD]2196[/TD]
[TD]AAB7[/TD]
[/TR]
[TR]
[TD]20140430[/TD]
[TD]3344[/TD]
[TD]XYZ[/TD]
[TD]2196[/TD]
[TD]AAB7[/TD]
[/TR]
[TR]
[TD]20140930[/TD]
[TD]3344[/TD]
[TD]XYZ[/TD]
[TD]21345[/TD]
[TD]T2FG[/TD]
[/TR]
[TR]
[TD]20140430[/TD]
[TD]3344[/TD]
[TD]XYZ[/TD]
[TD]21345[/TD]
[TD]N8J5[/TD]
[/TR]
[TR]
[TD]20140930[/TD]
[TD]3344[/TD]
[TD]FFM[/TD]
[TD]58461[/TD]
[TD]B7GT[/TD]
[/TR]
[TR]
[TD]20140430[/TD]
[TD]3344[/TD]
[TD]FFM[/TD]
[TD]58461[/TD]
[TD]N8J5[/TD]
[/TR]
</tbody>[/TABLE]


I have the file sorted by column D and then E, but what I need to identify next is whats difficult. I need to validate if the same code (column E) and same account (column D) appear in both April and September (column A). If so I need that highlighted so i can delete the data.

Basically, I need to keep any rows where column B, C & D are the same but column E are different based on the date in column A.

I know how to use conditional formatting to delete duplicate rows, but

 

[Rick Rothstein]

Duplicate posting of this one here...

http://www.mrexcel.com/forum/excel-questions/810548-urgent-i-neespecial-sorting.html

 

[MARK858]

Also a duplicate of the thread below as well

http://www.mrexcel.com/forum/excel-questions/810553-help-special-sorting.html