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)
Bu sure you correctly use first cell of the range to apply in formula, in general it shall work
Here first of duplicated values is highlighted and any value without duplicates.
That worked perfectly. Now is there a way to highlight the first of any duplicates in a column? In this spread sheet there are groups of rows that have #s that I need to highlight the first of each new group of duplicate numbers. The last calculation does not work as it only hight lights the first # that is a duplicate, not the first of the group of duplicates. if that makes sense.
Select K2:K100 or however far down as necessary. K2 should be the active cell in the selection.
Create a rule with formula
=AND(K2<>K1, K2=K3)
