Compare two columns

[Guest]

Hello,

I have two columns in the same sheet which contain cells with identical
results. I want to delete any result that is the same in both columns. Any
suggestions?

Column A Column B
abc jkl
def abc
ghi mno

Want to write a function to delete abc

Thanks.

 

[Guest]

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