Bug in Advanced filter

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

questions on advanced filter 4
Advanced Filter 1
Advanced Filter Grayed Out??? 3
Advanced Filter not pulling exact matches 1
Unique Records Filter 0
Sorting multiple columns that have similar data 0
Excel Advanced filter - Filtering using dates 5
unique records by advanced filter 10

Top