View Single Post
  #2   Report Post  
Art
 
Posts: n/a
Default

This might not be what you're looking for, but:

You can put a "conditional format" in each column, that would check for the
presence of an item in the other column. This would then change the
highlighting or color, thus allowing you to see the duplicated items.

So, working in columns column A and B as in your example. Highlight column
A. Select Format, Conditional Formatting. Change Condition1 from "Cell
Value Is" to "Formula Is".

In the formula box, type: =COUNTIF($A:$A,B1)0. Then pick a format you'd
like to use for this.

Now, if you want to delete items from both columns, be careful. As soon as
you delete the item from one column, the formatting in the other column will
go back to normal. One way to deal with this would be to turn off automatic
calculations.

Art