I have a spreadsheet that i need to clean up. I have many duplicates that i
need to delete. Here is the problem; I don't want to delete ALL the
duplicates.
Here's an example:

A B C D
1 2/4/2005 F2 60A155-100 105588 Duplicate
2 2/1/2005 RE 60A155-100 105588 Duplicate
3 9/30/2004 F2 60A155-100 105445 Duplicate
4 9/30/2004 RE 60A155-100 105445 Duplicate
5 9/30/2004 RE 60A155-100 105445 Duplicate


If B1="F2" AND it is more recent (A) then the subsequent "RE" in B2, i want
to leave it and delete the "RE" line (Row 2).

But if :
A B C D
1 2/4/2005 F2 60A155-100 105588 Duplicate
2 2/1/2005 RE 60A155-100 105588 Duplicate
4 9/30/2004 RE 60A155-100 105445 Duplicate
5 9/30/2004 F2 60A155-100 105445 Duplicate


If B4="RE" AND is the more recent one, i want to delete both rows 4 and 5
both.

any ideas? i can go through each one but my report is huge!

TIA

James