I'm a little bit confused on what you are considering a duplicate. You
description if incosistent with the data you provided.

I can write a macro, if you crrect your error. first I would sort the
data by date (descending order) and any other columns that need to be
sorted to put duplicates in adjacent rows. I would do is to add a
formula into the worksheet in an auxilary column that would look for
duplicates. This is an example of the formula starting in row 2. The
formula compares row 1 with row 2. then copy the formula down to
worksheet.

=IF(AND(B1=B2,E1=E2),TRUE,FALSE)

the duplicates would be the formulas that returned True. I would then
use autofilter to remove the TRUE rows. All this can be done using a
macro. Let me know which columns need to be compared and if there is a
header row that need to be skipped.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=154326

Microsoft Office Help