I'm betting they are not duplicates.

You could have an extra space or an html non-breaking space.

Try TRIM ing the data in a helper column.

=TRIM(cellref) and copy down.

TRIM won't find non-breaking spaces.

Try to remove those using editreplace

What: Alt + 0160........0160 on the NumPad

With: nothing


Gord Dibben MS Excel MVP

On Thu, 17 Sep 2009 15:01:01 -0700, boombox
wrote:

I have a giant list of emails that I need to clean up, and I'd like to do it
by highlighing the duplicates. I use the conditional formatting tool, and it
only works for some. I can clearly see duplicates that it isn't
highlighting, though it will for others. It is just text, not merged or
hyperlinked or formatted any different. For the duplicates it doesn't
highlight, I can copy one dup and "find" (ctrl + f) the other. If it can
"find" both duplicates, and it will highlight others, why doesn't it work
consistently??