Hide Dups

Format don't show

Duplicate entries can be formatted to "disappear", but still be available for computation.

1. Select the range
   
   
2. Goto Format>Conditional Formatting
   
   
3. Select Formula Is
   
   
4. Enter
   =A2=A1
   
   
5. Click the Format button.
   
   
6. Select a font color to match the cell background color.
   
   
7. Click OK and OK

Dups can also stand out:

1. Select the range
   
   
2. Go to Format>Conditional Formatting
   
   
3. Choose Formula Is
   
   
4. Enter
   =COUNTIF($A$2:$A$100,A2)>1
   
   
5. Click the Format button.
   
   
6. Select a font or background color for highlighting.
   
   
7. Click OK and OK

Hide Duplicate Values

Also:
Hide Records with Duplicate Cell Entries



See all Topics