If there is only one duplicate--and it's the top row of the range and another
row of the range, then I bet you don't have headers and excel is using that top
piece of data as the header.

Add headers if you don't have them.

If that doesn't help, you may want to share some snippets of data and your exact
steps when you run the advanced filter (along with the version of excel).

ps. If you're filtering a field that consists of numbers/digits, then make sure
that all your fields are the same type--either text or real numbers.

(And changing the number format isn't enough to ensure this!)

If you need help changing this data, explain what you want to do (text to real
numbers or numbers to text).

Joyce wrote:

Hello,

I'm applying an advanced filter, in place, unique values only.

However, it returns doubles. I have used Trim and have also created IF
statements checking if two of the duplicates are the same, cell by cell, and
they are.

Any ideas?

Thanks

--

Dave Peterson