Hi,
I would like to highlight case sensitive duplicate ID's in column A. In this example the difference is the "h" or "H", everything else is the same 00000khK72 OR 00000kHK72 and therefore should not receive conditional format, only exact match, with the same "H" should be highlighted. Standard conditional formatting ignores the case and formats both the 00000khK72 AND 00000kHK72 as being duplicates and they are not.
Any help is greatly appreciated.
Thanks
try
=AND(A1<>"",SUMPRODUCT(EXACT($A$1:$A$1000,A1)*1)>1)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi & welcome to the Board.
Select the cells in col A & use this formula
=SUMPRODUCT((EXACT($A$2:$A$100,A2))*($A$2:$A$100<>""))>1
Thank you both very much, =AND(A1<>"",SUMPRODUCT(EXACT($A$1:$A$1000,A1)*1)>1) works perfectly.
Thanks Again.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks