Advanced filter problems

[shav]

Hi all,
can anyone tell me why I am duplicate entries when I'm usin
unique records only with adavanced filter. A copy of the file attached
Cheers
Shan

+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelforum.com/attachment.php?postid=2697
+-------------------------------------------------------------------

 

[Debra Dalgleish]

If your list doesn't have a heading, the first cell will be treated as a
heading, and may be included twice.

Or, entries may look the same, but have subtle differences, such as
extra spaces.

 

[Dave Peterson]

I don't open attachments/files, but any chance your data doesn't have a header?

If it doesn't then excel will treat the first cell as a header and that could
look like a duplicate.

Any leading/trailing/embedded space differences?

Use some helper cells to see if the ones that look like duplicates are really
duplicates:

=b3=b9

and
=len(b3)
=len(b9)

and
=trim(b3)=trim(b9)

just for some checks.