Help!!!! Special sorting

[moonlight22]

Hi,

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

[TABLE="class: cms_table, width: 304"]
<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 that's not what i need to do because of my requirement of column A.

Please let me know if you have any ideas, the file is very large and i need to finish this before tomorrow a.m...eeek!!

cheers!!

 

[MARK858]

Duplicate of the threads below

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

http://www.mrexcel.com/forum/excel-questions/810547-urgent-special-sorting.html