Bug in Advanced filter

  • Thread starter Thread starter GregNga
  • Start date Start date
G

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.
 
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
 
Back
Top