Help!!!! Special sorting

Status
Not open for further replies.

moonlight22

New Member
Joined
Aug 15, 2014
Messages
24
Hi,

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

ABCDE
201409303344XYZ141AAB7
201404303344XYZ141AAB7
201409303344XYZ2196AAB7
201404303344XYZ2196AAB7
201409303344XYZ21345T2FG
201404303344XYZ21345N8J5
201409303344FFM58461B7GT
201404303344FFM58461N8J5

<tbody>
</tbody>



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

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top