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)