Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare two columns
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
how do I compare columns in two different workbooks? | Excel Discussion (Misc queries) | |||
How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
Compare Columns | Excel Discussion (Misc queries) | |||
compare columns of different worksheets | Excel Discussion (Misc queries) |