Advance filter not filtering unique records only

[forbes]

Hi,
I have a user who has four large lists, he wants to combine them into
two master lists; but hide or delete duplicates. I showed him how to
use Advance Filter and he said it worked perfectly for combination;
but the second worksheet did not filter only unique records. He
assured me he followed the directions and click "Unique Records" in
the Advance filter dialog box; but it didn't work.

Can you guys give me a few more avenues he can pursue: (I suggested
misspelled entries, and double-checking his work.)

Thanks
Kim

 

[Dave Peterson]

I agree with you. My bet is that there is a typo or even an extra space (at the
end) that isn't noticeable.

Tell him to pick out two cells that he thinks are duplicates (say A12 and A97).

the put
=a12=a97
in an empty cell.

If he sees True, then I'm wrong and there's something else at work.

If he sees False, tell him to look closer.