Forum Discussion
Help: Highlighting Only the First Duplicate
Select B1:B9 (or to the end of the data). B1 should be the active cell in the selection.
Create a rule of type 'Use a formula to determine which cells to format' with formula
=AND(ISNUMBER(MATCH(B1,A:A,0)),COUNTIF(B$1:B1,B1)=1)
Select B1:B9 (or to the end of the data). B1 should be the active cell in the selection.
Create a rule of type 'Use a formula to determine which cells to format' with formula
=AND(ISNUMBER(MATCH(B1,A:A,0)),COUNTIF(B$1:B1,B1)=1)
HansVogelaar - I tested it with the sample text, and it works. But I'm having difficulty applying it to my project. The columns contain email addresses along with some appended (concatenated) text to serve as a unique identifier.
Originally, I had an asterisk between the date (first 8 characters) and the email. I thought it might be interfering, so I replaced it with "ZZZ" and can remove it later. I then thought the "@" was the problem, so I replaced that with "XXX" and can remove that later. Regardless, the formula you suggested should work here, right? It doesn't, and I can't figure out why not.
In writing this, I also replace the period in ".com" just to see. Nothing. Still doesn't work. It's just text, so why isn't it being recognized as a match?
Could you attach a sample workbook, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- https://mygsu-my.sharepoint.com/:x:/g/personal/dedgerton1_gsu_edu/EUpGQvA9PwJFqvsJZT5YyPwBAFzKdtiuR_eel2eGnrRVJg?e=EwVxhv
Thanks! This is what I see when I download and open your workbook:
The conditional formatting rule appears to work as intended.