Hello,
I have a list of values I want to find duplicates of. I have used conditional formatting but it appears to highlight alot of values that are not duplicates (through manual searching I can only highlight one true duplicate - in column B on attached file).
Does conditional formatting have a maximum chaarcter count it can recognise? I tried googling the problem but nothing came up.
Thanks
Innes
Congratulations, you have just passed the 15 digit barrier, welcome to the world of quantum formule!!!! ......
Try this for your C/F
If you use this in a worksheet cell you have to confirm it with Ctrl+Shift+Enter not just enter, its an array formula.
Please Login or Register to view this content.
Conditional formatting treats all formulae as arrays, so no need for the curly braces.
In the attached ...
See Column B as an explanation of how it works and Column D for how to remove the duplicates.
This link will explain it better than I can Daily Dose of Excel - COUNTIF Bug
Last edited by Marcol; 05-02-2012 at 12:39 PM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks