Delete duplicates with macro keeping only the newest by date

[tmpollard]

Hello,
Can I please get some help with a macro, I put the columns and rows in to better define what I'm looking for. The keys for me are column B and column D.

Row 2 and row 3 have the same unit number whenever this is identified look at column D and only keep the row with the most current time. In this example row 3 would be kept and row 2 deleted from the spreadsheet.

My spreadsheet will have up to 100000 rows of data. Thank you all.

Column A	Column B	Column c	Column D	Column E	Column F
Row 1	Green Jacket	Created On	Created At	Product	Grams Weight
Row 2	Unit 1	5/1/2015	17:00:40	A	71.907
Row 3	Unit 1	5/1/2015	17:23:56	A	264.216
Row 4	Unit 2	5/1/2015	17:02:48	A	71.907
Row 5	Unit 2	5/1/2015	17:24:04	A	264.216
Row 6	Unit 3	5/1/2015	17:03:02	A	71.907
Row 7	Unit 3	5/1/2015	17:24:12	A	264.216
Row 8	Unit 4	5/1/2015	17:03:17	A	71.907
Row 9	Unit 4	5/1/2015	17:24:23	A	264.216
Row 10	Unit 5	5/1/2015	17:03:30	A	126.255
Row 11	Unit 5	5/1/2015	17:24:35	A	464.887
Row 12	Unit 6	5/1/2015	17:03:44	A	71.907
Row 13	Unit 6	5/1/2015	17:24:47	A	264.216
Row 14	Unit 7	5/1/2015	17:03:56	A	71.907
Row 15	Unit 7	5/1/2015	17:24:58	A	264.216
Row 16	Unit 8	5/1/2015	17:04:14	A	71.907
Row 17	Unit 8	5/1/2015	17:25:10	A	264.216

<tbody>
</tbody>

​

 

[igold]

Are there ever going to be more that two instances of the same Unit name in Column B? And is Column B always going to be sorted by name?

 

[tmpollard]

In the data sets that i've viewed there has always only been two but it is possible that it could be more.