Duplicate Row Scenario

evanswright

Board Regular
Joined
Mar 22, 2007
Messages
94
Hello All,

The following is my data:
Book1
ABCDEFGHIJKLM
1H2222000120070221PRODDET7772526007529220070101233595893714618C
2H2222000120070221PRODDET77825260077372200701012335957591544305C
3H2222000120070221PRODDET15412526145051120070102100363969154068C
4H2222000120070221PRODDET15422526146481120070102100364474712613C
5H2222000120070221PRODDET154325261470311200701021003645378156010C
6H2222000120070221PRODDET95825262046671200701021839291406036005C
7H2222000120070221PRODDET185925263003541200701021802005172572860C
8H2222000120070221PRODDET14202526304094220070102203941550111056303C
9H2222000120070221PRODDET18602526315676120070102182659759762503301C
10H2222000120070221PRODDET12552526325170220070102140030969073166C
11H2222000120070221PRODDET94625263263472200701021818767186109005C
12H2222000120070221PRODDET293252634535222007010227935324542131C
13H2222000120070221PRODDET29425263457202200701022793512411730C
14H2222000520070530PRODDET173825263457202200701022793512411730CA
15H2222000120070221PRODDET295252634593122007010227935060505008401C
16H2222000520070530PRODDET1739252634593122007010227935060505008401CA
17H2220000120070221PRODDET10152530959230220070108792150111043002C
18H2220001220070328PRODDET13442530959230220070108792150111043002CD
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.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,181,098
Messages
5,928,055
Members
436,586
Latest member
latintxn

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