Delete duplicates in one column, based on dates of another?

[eptesicus]

I run a report and macro daily which part of consists of importing batch numbers and ship dates into a spreadsheet. More often than not, duplicate batches are imported, but the ship dates may vary. If a batch (545319 for example) is found multiple times with ship dates of 9/21/2012, 9/20/2012, and 9/24/2012, I would want the date furthest out from today to remain (9/24/2012), but delete the rows of the rest.

Example of data:

(Col. A) (Col. B)
BATCH DATE
507819 9/20/2012
586502 9/20/2012
584060 9/20/2012
586002 9/20/2012
583494 9/21/2012
583494 9/21/2012
585409 9/21/2012
585409 9/21/2012
585409 9/21/2012
585409 9/21/2012
585409 9/21/2012
583523 9/21/2012
578497 9/21/2012
584872 9/21/2012
584872 9/21/2012
584755 9/21/2012
584992 9/21/2012
584992 9/21/2012
583541 9/21/2012
583541 9/21/2012
583523 9/21/2012
583523 9/21/2012
585409 9/22/2012
585409 9/22/2012
585409 9/23/2012
585409 9/23/2012
577466 9/23/2012
585095 9/23/2012
585087 9/24/2012
584753 9/24/2012
578497 9/24/2012
585630 9/24/2012
583494 9/24/2012
585410 9/24/2012

Thank you in advance!

[eptesicus]

Here is the current code for the import macro:

Please Login or Register  to view this content.

[arlu1201]

I see instances where there are duplicates, all having the same date 9/21, what should be done in this case?

[eptesicus]

I see instances where there are duplicates, all having the same date 9/21, what should be done in this case?

If there are duplicates and the dates are the same, then the duplicates should be deleted. Something like below if that helps.

525525 9/20 #Delete
525525 9/20 #Delete
525525 9/20 #Delete
525525 9/21 #Delete
525525 9/21 #Delete
525525 9/24 #Either one of these are ok, but keep only one.
525525 9/24 " "