I used the conditional formatting to compare 2 rows of customer account numbers to find duplicates. This is the formula I used =(COUNTIF($E:$E,G1)=0)*(G1<>"") I need to make another column with an X in it for the duplicates. Is there something I can add to the conditonal formula to do this? The list has over 10,000 customers.
Can you not make an IF formula in the new column that returns an X if the COUNTIF is above 1 then filter on non-blanks to return a unique list of duplicate customers?
Excel Business Forums Administrator
Posted by Excel Helper on
Displaying page 1 of 1
Excel templates and solutions matched for Conditional Formatting:
