Forum Discussion
DanielAtGSU
Apr 15, 2022Copper Contributor
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...
- Apr 15, 2022
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)
DanielAtGSU
Copper Contributor
It's working now. I found the error. Thank you both!
SergeiBaklan
Apr 18, 2022MVP
Great to know you sorted this out.