Advanced filter problems

S

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
+-------------------------------------------------------------------
 
D

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

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.
 

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


Top