I think I have discovered a bug in the way Advanced Filter filters out
duplicates. When I perform this function and have the results pasted to
another location (or new worksheet) if the first 2 rows are duplicate they
are treated as not being duplicate. That is, it lists the first 2 rows in the
target location even though they are duplicate. It seems to work fine for
other rows.