Bug in Advanced filter

[GregNga]

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.

 

[Gord Dibben]

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