Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting duplicates...except it doesn't
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting duplicates...except it doesn't
It depends how you are checking for duplicates. The formula you are using
would have been useful. Assuming you are using a formula like: =a1=a2 This will check the entire cell contents, including any spaces or unprintable characters which may not display. When you use ctrl-f, you're checking the cell to see if it contains the string you entered. Trailing spaces, for example, would be ignored. You can try using the Trim function, as in: =trim(a1)=trim(a2) That may solve your problem. If not, you'll need to go searching for extraneous undisplayed characters. Regards, Fred. "boombox" wrote in message ... 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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting duplicates...except it doesn't
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help with Highlighting duplicates across several sheets | Excel Worksheet Functions | |||
highlighting duplicates | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Help with Highlighting all duplicates in a row | Excel Discussion (Misc queries) | |||
Highlighting Duplicates | New Users to Excel |