Duplicate Row Scenario

[evanswright]

Hello All,

The following is my data:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	H2222000120070221PROD	DET	777	2526007529		2	20070101		2335958		93714618	C
2	H2222000120070221PROD	DET	778	2526007737		2	20070101		2335957		591544305	C
3	H2222000120070221PROD	DET	1541	2526145051		1	20070102		1003639		69154068	C
4	H2222000120070221PROD	DET	1542	2526146481		1	20070102		1003644		74712613	C
5	H2222000120070221PROD	DET	1543	2526147031		1	20070102		1003645		378156010	C
6	H2222000120070221PROD	DET	958	2526204667		1	20070102		1839291		406036005	C
7	H2222000120070221PROD	DET	1859	2526300354		1	20070102		1802005		172572860	C
8	H2222000120070221PROD	DET	1420	2526304094		2	20070102		2039415		50111056303	C
9	H2222000120070221PROD	DET	1860	2526315676		1	20070102		1826597		59762503301	C
10	H2222000120070221PROD	DET	1255	2526325170		2	20070102		1400309		69073166	C
11	H2222000120070221PROD	DET	946	2526326347		2	20070102		1818767		186109005	C
12	H2222000120070221PROD	DET	293	2526345352		2	20070102		279353		24542131	C
13	H2222000120070221PROD	DET	294	2526345720		2	20070102		279351		2411730	C
14	H2222000520070530PROD	DET	1738	2526345720		2	20070102		279351		2411730	C	A
15	H2222000120070221PROD	DET	295	2526345931		2	20070102		279350		60505008401	C
16	H2222000520070530PROD	DET	1739	2526345931		2	20070102		279350		60505008401	C	A
17	H2220000120070221PROD	DET	1015	2530959230		2	20070108		7921		50111043002	C
18	H2220001220070328PROD	DET	1344	2530959230		2	20070108		7921		50111043002	C	D
Sheet1

What I need to do is the following:
1.) For every duplicate item in column D, I need to only select the line with the later of the production date from column A (delete the line with the earlier production date)
2.)BUT if the duplicate item in column D has a "D" in Column M, I need to delete both of the duplicate line items.

Any advise on how to go about this process?

Thank you very much so much.