Forum Discussion
Solved
Help: Highlighting Only the First Duplicate
I have two columns of data. I'm comfortable with conditional logic and I've made the data consistent between the two columns so that highlighting duplicates is error-proof. Here's where it gets b...
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)
Again, this is just sample text. The working file has 328 rows in Column A and 631 in Column B. No other changes to the formula, and still nothing is highlighting.
Great to know you sorted this out.
- It's working now. I found the error. Thank you both!
- It seems to work in the sample file. Can't get it to work in the real one.
So, now it works?
- Corrected. I was actively expanding the data to a range that matched my working file.
