Bug in Advanced filter
 

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.

Bug in Advanced filter
 

It is not a bug.

Excel treats the top value as a Title/list header unless you tell it not to.

So.......you get Cat as Title and Cat as first unique in the list below.


Gord Dibben MS Excel MVP

On Sat, 13 Mar 2010 14:25:01 -0800, GregNga
wrote:

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.